Skip to Content
0
Former Member
Nov 02, 2012 at 03:12 PM

Round error in total percentages

300 Views

In my webi report I have a column defined with format number percentage. Due to rounding, it is adding up to 100.01%. The report is required to have 2 decimal place precision.

If I take the numbers being divided using a calculator - here are the results. They add to 1.

0.9866828521968984

0.0121606964566618

0.0011564513464398

But with rounding, they are displayed as 98.67, 1.22 and .12 which add up to 100.01%.

Is there any way to fix this problem?