Were preparing a report and the detail commission values are rounded to two
decimals. I also calculate commission as Total Revenue x 5% (rounded to two
decimals). The problem is the sum of the rounded detail values does not
equal the Total Revenue x 5% value.

For example:

Total Revenue = $117,524.11 and the Commission = $5,876.21 (5%).

However, when multiplying the row-level detail by 5% and rounding to two
places and then summing the column I get $5,876.71, a $0.50 increase.

Is there anyway to add the rounded values at the detail level so that it
equals the Total Revenue x 5% or am I trying to mix apples and organes?

Thanks for the help.........

--
JT