[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Re: sum up float values problem

Subject: Re: sum up float values problem
From: "Dimitre Novatchev" <dnovatchev@xxxxxxxxx>
Date: Thu, 27 Apr 2006 09:14:44 -0700
Re:  sum up float values problem
Exactly as explained by Dr. Kay:

sum(/*/*/xs:double(translate(.,',','.')))



--
Cheers,
Dimitre Novatchev
---------------------------------------
Truly great madness cannot be achieved without significant intelligence.



On 4/27/06, Markus Gamperl <markus.gamperl@xxxxxx> wrote:
Dear experts!

XSL 1.0:
I have got the following XML:

<POSITION>
 <LSUM>14,68</LSUM>
 <LSUM>321</LSUM>
 <LSUM>13</LSUM>
 <LSUM>100,6</LSUM>
...
</POSITION>

I want to sum up all my LSUM elements. When I do a sum(//LSUM) I only get a
number value, not a float value... This would work if the float values are
separated with a '.' not a ',' (eg. 14.68). But I get the values separated
with a ','...

So I had following idea:
sum(translate(//LSUM,',','.'))

But the translate function only returns the first node (14.68) of the
nodeset...

Do you have an idea how to solve this issue simply?

Thanks
Markus

--
Echte DSL-Flatrate dauerhaft f|r 0,- Euro*!
"Feel free" mit GMX DSL! http://www.gmx.net/de/go/dsl

Current Thread

Back To School Sale!

Save 30% off all Stylus Studio 2008 Products when you purchase from our Online Shop.

Offer ends August 31, 2008.

Coupon Code
TRTY-C4JV-OFF

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2007 All Rights Reserved.