Hello all, I have a rounding issue. I have a report which creates 12 rows of data, each row calculated with the following formula:

truncate((truncate(round({Command.TAXABLE_KMS}/{Command.KILO_PER_LITRE}), 0) - {Command.TAX_PAID_LITRES_PURCHASED}), 0) * {Command.TAX_RATE}

Which creates these twelve rows:

3,346.57
3,029.03
22.18
1,658.43
2.77
380.38
419.19
121.51
-4.47
203.90
709.02
196.50

Now, I want to find a total of these values, which is 10085.01, but when I do a simple Sum, it gives me a total of 10085.00. Iis there anyway to have it just calculate from the numbers showing, rather then from the formula calculating each row??


Edited by shamrock31 - 02 Aug 2012 at 5:55am