Floating point numbers

[John Wilkinson]

Hi,
I am creating a table of values. One column is the addition of the other 2
columns.Both columns are floating point, and may be any value 0-100
For some values we find that we get a good output from the sum, such
as,97.67+2.31=99.98, others we get problems: 96.56+0.54=79.100000000001.
How do I truncate these figures to 2 decimal places?

 

[Martin Honnen]

John Wilkinson wrote:

I am creating a table of values. One column is the addition of the other 2
columns.Both columns are floating point, and may be any value 0-100
For some values we find that we get a good output from the sum, such
as,97.67+2.31=99.98, others we get problems: 96.56+0.54=79.100000000001.
How do I truncate these figures to 2 decimal places?

Well what language are you using, as you are posting in an XML group
XSLT/XPath 1.0 perhaps?
In XPath 1.0 you have the round function
<http://www.w3.org/TR/xpath#function-round>
and in XSLT 1.0 you additionally have the format-number function
<http://www.w3.org/TR/xslt#format-number>

 

[John Wilkinson]

www.w3.org/TR/xslt#format-number>

Thanks Martin,
It took a while to decipher the syntax of format-number, but I got there in
the end.