>Archive Index
>microsoft.public.xsl Archive Home
>Recent entries

>Thread Prev - Re: I need to calculate sum of product of elements
>Thread Next - Re: I need to calculate sum of product of elements

Re: I need to calculate sum of product of elements

From: Martin Honnen <mahotrash@-----.-->
To: NULL
Date: 12/14/2007 12:49:00 PM

khalil_mi@h... wrote:

> there is one more issue. Some numbers have comma separated (such as
> 18,123) which gives me an error
> 
> I tried to use the function number() but it gives me NAN

If you store number values in an XML document to be processed by an XSLT 
stylesheet then you should use the supported number formats (e.g. 
xs:double).
If you don't then you have to convert to that format.
What do you want to do with 18,123, treat it as 18.123?
Then use translate and xs:double e.g.

<xsl:stylesheet
   xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
   xmlns:xs="http://www.w3.org/2001/XMLSchema"
   exclude-result-prefixes="xs"
   version="2.0">
   <xsl:output method="text"/>
   <xsl:template match="/">
     <xsl:value-of select="sum(for $line in csv/line return 
$line/number[1]/xs:double(translate(., ',', '.')) * 
$line/number[3]/xs:double(translate(., ',', '.')))"/>
   </xsl:template>
</xsl:stylesheet>

-- 

	Martin Honnen --- MVP XML
	http://JavaScript.FAQTs.com/

>Thread Prev - Re: I need to calculate sum of product of elements
>Thread Next - Re: I need to calculate sum of product of elements

>Archive Index
>microsoft.public.xsl Archive Home
>Recent entries

Altova Mailing List Archives

Re: I need to calculate sum of product of elements