Report summing wrong

  • Thread starter Thread starter Oiii
  • Start date Start date
O

Oiii

I have a report that is summing two currency amounts
ending in .88 cents and it totals them as .75 which is of
course wrong. I've checked the currency properties for all
the fields concerned as Currency, 2 decimal points. Any
suggestions?? Thank you.
 
Summing in a report rarely results in wrong results. How are you summing? I
expect this is a rounding issue. For instance .876 would display as .88 yet
when adding .876 a+ .876 = 1.752 which rounds to 1.75.
 
Oiii said:
I have a report that is summing two currency amounts
ending in .88 cents and it totals them as .75 which is of
course wrong. I've checked the currency properties for all
the fields concerned as Currency, 2 decimal points.
Click to expand...


That's the expected result if the .88 values were really
..875. For display purposes, the .875 numbers would be
rounded to two places and shown as .88, but their sum would
still be .75
 
Back
Top