Re: [xsl] sum up float values problem

Subject: Re: [xsl] sum up float values problem
From: "Dimitre Novatchev" <dnovatchev@xxxxxxxxx>
Date: Thu, 27 Apr 2006 09:14:44 -0700
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