Adding up Percentage calculated series of numbers????

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Adding up Percentage calculated series of numbers????
I am adding a series of numbers that have been rounded to the 2nd decimal
point. I have a calculation to receive a result, such as. (8.9%)123.00= 10.947
thus rounding gets (10.947 rounded to 10.95)
Now if a series of Rounded numbers are totaled (=Sum[Number]) in the footer
I will receive in the total a number that totals not the rounded numbers but
the "real" number out 10.947...... I am using currency format with 2 decimal
settings in the tables General property.
Example:
23.335 rounded = 23.34
12.259 rounded = 12.26
15.237 rounded = 15.24
18.248 rounded = 18.25
_______________________
Real Total 69.079 Rounded Total = 69.09 Or .01 higher than the Real sum
 
LD said:
Adding up Percentage calculated series of numbers????
I am adding a series of numbers that have been rounded to the 2nd decimal
point. I have a calculation to receive a result, such as. (8.9%)123.00= 10.947
thus rounding gets (10.947 rounded to 10.95)
Now if a series of Rounded numbers are totaled (=Sum[Number]) in the footer
I will receive in the total a number that totals not the rounded numbers but
the "real" number out 10.947...... I am using currency format with 2 decimal
settings in the tables General property.
Example:
23.335 rounded = 23.34
12.259 rounded = 12.26
15.237 rounded = 15.24
18.248 rounded = 18.25
_______________________
Real Total 69.079 Rounded Total = 69.09 Or .01 higher than the Real sum
Click to expand...


That's exactly what you should get. This happens because
Round(Sum()) is Not Equal to Sum(Round()) in most cases.

Either stop rounding the individual numbers (most accurate)
OR sum the rounded numbers (less accurate, but people won't
question it).
 
Back
Top