Re: [xsl] sum function

["cutlass" <cutlass@xxxxxxxxxxx>]

u may use

translate() function to replace all commas with nothing then your sum will
work

and you may also use the format-number() function to make a mask for
formatting the number

cheers, jim fuller


----- Original Message -----
From: "Hesselberth, Jan" <Jan.Hesselberth@xxxxxxxxxxxxxxxxxx>
To: <XSL-List@xxxxxxxxxxxxxxxxxxxxxx>
Sent: Friday, November 16, 2001 3:09 PM
Subject: [xsl] sum function


> How do I use the sum function on xml such as:
>
> <Amount>12,345.12</Amount>
> <Amount>132,345.12</Amount>
> <Amount>2,345.12</Amount>
>
> If I use Total Price = <xsl:value-of select="sum(//Amount)"/> I get the
> result NaN. However, if the data does not contain ',' the sum works
> correctly.
> Any help appreciated.
> Regards
> Jan
>
>
>
>
>
>
> --------------------------------------------------------------------------
> CONFIDENTIALITY
> The information contained in this e-mail and any files transmitted with it
> is private and confidential. It is intended for the named addressee only.
> If you are not the intended addressee you are prohibited from
> storing, copying or using the information in any way.
> If you received this e-mail due to a transmission error please notify the
> sender immediately. No liability is accepted by Northern Rock
> for any losses caused by viruses contracted during transit
> over the Internet or present in any receiving system.
> This e-mail is not intended to create legally binding commitments on
> behalf of Northern Rock plc, nor do its contents reflect the corporate
> views or policies of Northern Rock plc.
> --------------------------------------------------------------------------
>
>
>  XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
>


 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list