Format values in XSLT 1

[jmeckley]

I have a list of sales displayed on my page. In the footer of the table I want to have the sum of sales.

All the sales have 2 decimal places, yet the total is carried out 10 decimal places.
[tt]Example:
100.00
150.25
50.25
1000.25

Total: 1300.7499999997
[/tt]
How can I format the sum so the decimal place is only 2 digits?

Jason Meckley
Database Analyst
WITF

 

[jaybytez]

You can use the format-number method in your xslt.

This page has example of how to do that:

http://www.w3schools.com/xsl/func_formatnumber.asp

-jay