Subject: Re: 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
|
Cart
