Re: sum up float values problem

Play the video

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

Current Thread
sum up float values problem Markus Gamperl - 27 Apr 2006 14:44:26 -0000 Michael Kay - 27 Apr 2006 15:10:41 -0000 Dimitre Novatchev - 27 Apr 2006 16:16:41 -0000 <= Florent Georges - 27 Apr 2006 17:46:44 -0000 Dimitre Novatchev - 27 Apr 2006 19:04:54 -0000 Markus Gamperl - 28 Apr 2006 08:03:52 -0000 Florent Georges - 28 Apr 2006 08:22:28 -0000

<- Previous	Index	Next ->
RE: sum up float values probl, Michael Kay	Thread	Re: sum up float values probl, Florent Georges
RE: sum up float values probl, Michael Kay	Date	Re: Question about cross refe, Jay Bryant
	Month

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

RSS 2.0
Atom 0.3


	Stylus Studio® Developer Network \| Contact Us \| Email this page