How to make CR not avg sums

I have created a CR that pulls info from MAS90 for a 401(k) report that calculates the employer contribution and then "brings in" the employee contribution that was deducted from their pay.

These are in three columns including a total column adding the EE and ER amounts together for each employee.

My problem is the column totals (grand total) for these three columns at the bottom of the page are off by a few cents. If I manually add up the numbers, I get the correct amount. For some reason CR is averaging up or down instead of EXACT amounts.

I have checked my regional settings for Windows XP. I have tried a custom number setting in CR. Nothing is working.

I also tried doing a running total for each column - that didn't work either. Amounts were still off, but could see them in the running total(s).

Can anyone help, please? Thank you!
JulesI would guess that as your report calculates the contributions that the calculated value isn't exact to 2 decimal places but you are displaying it to 2dp.
Have you tried truncating the calculated values to 2dp and totalling on that?|||Jagan, how do I "truncate" the numbers?

Sorry I'm such a dummy here!

Jules|||Truncate(1.999)

Returns 1.

Truncate(12346.33, 1)

Returns 12346.3.

Truncate(12345.33, -2)

Returns 12300.00.

F1 it helps ... :-)