numeric value (double) with many decimal 0s?

M

Martin Eckart

Hi guys,

I have a form containing many different prices. At the end there is a field
which sums up all of them and gives you the total price.
All fields are data type double. If I sum up a few of them like 0.45, 0.45,
0.40 and 0.95 I get this as result: 2.600000000

Often times I even get 2.6000001 or so. I know that I can format the number
in the text box of the total price but this does not modify the xml. So, any
suggestions how to get rid of the many decimals (most of them being 0) so
that the above gets displayed like "2.6"?

Thanks to all of you,

Martin
 
S

S.Y.M. Wong-A-Ton

Search this newsgroup for a post with the title "Incorrect results in
Infopath calculation - might be a bug?". There Bojana Marjanovic [MSFT]
explained why this occurs.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Infopath calculation error with decimal points 1
Inconsistent rule behaviour when value has 2 decimal places 0
Automation of scanned file storage based on content 0
Would like to input 3 letters into a cell, each having a different numerical value 5
Inconsistent rounding on currency fields 3
Excel not totaling right amount 4
Adding rows and problem assigning values to numeric fields in the 0
Rounding down or not at all in Forms 8

Top