[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] Re: sum function
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: 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
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|