Hi,

I have an issue with crystal reports calculating the incorrect sum from running totals, for example I have the column used time:

0.55
0.20
0.34
0.20
0.47

I use a running total to add the column up, I also use a running total to count the rows. This gives me a figure of 0.37 which at first seems fine, however when I double check the calculation on a calculator I get 0.352??

I have a reset in place for every change of group! For every group that has bigger values, the spread from the sum gets bigger.

Any ideas would be great

Unfortunately I have checked the rounding s and it adds up to the exact row amounts yet the total is incorrect   

Just a running total.

I have since seen that when displaying the final values in the group footer, it's adding the last row in twice so the row count is 6 not 5?

Why is it doing that?

Thanks

Edited by adders - 05 Aug 2013 at 1:29am

Both running totals are below:

WhilePrintingRecords
NumverVar UsedHours;
UsedHours := UsedHours + {UsedTime}

Used time is just total time / total goods (this currently works fine)

WhilePrintingRecords
NumverVar Records;
Records := Records + 1 (I then have my count records RT)

Both running totals are run in the details section.

I then use RT_UsedHours / RT_Records to get the time taken (In the group footer)

I have a reset in the group which also works fine.

Lovely thanks, all sorted.