Rounding data in XSL to 2 decimal places 1

[deepasona]

Hi,


<xsl:value-of select=&quot;sum(PersProd/ProductNode/SectionPart/UsageItem/Amount/TaxAmount/Value)&quot;/>)

The output value is
21.599999999999998

How to round it to 2 decimal places

 

[kibje]

i am no xml genie but i think this might be done with a small trick , eg. like this

say var a is the number you now have

try
floor(a*100)/100

or
ceiling(a*100)/100

depending on whether you would rather round up or down.
Hope this helps

kib.at.kibje.com

 

[kibje]

<xsl:value-of select=&quot;floor(sum(PersProd/ProductNode/SectionPart/UsageItem/Amount/TaxAmount/Value)*100)/100)&quot; />

that should do it

 

[Hexonx]

Using XmlSpy 4.4, it didn't like using '/' as the division operator. I had to use 'div' operator instead. Mine looked like this:

&lt;xsl:value-of select=&quot;floor(sum(PersProd/ProductNode/SectionPart/UsageItem/Amount/TaxAmount/Value)*100) div 100&quot;/&gt;

 

[jd323]

or you can use the function

<xsl:variable name="number" select="sum(PersProd/ProductNode/SectionPart/UsageItem/Amount/TaxAmount/Value)" />
<xsl:value-of select="format-number($number,'#.##')"/>