Report summing wrong

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.
 
D

Duane Hookom

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.
 
M

Marshall Barton

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
 
Top