Hi there,

I have created this formula to hold my running total. It look like this...
Code:
WhilePrintingRecords;
NumberVar totalHours;
totalHours := totalHours + {GetEmployeeHoursAllByDate.Hours};
And in the header for each grouping I have this.
Code:
WhilePrintingRecords;
NumberVar totalHours := 0;
which resets the total at the beginning of every grouping.
It works fine when I look at the formula in the detail section but if I put the total hours formula in the footer it is totally wrong in a way I can't understand sometimes wildly under or over and sometimes it has the value of the last Hours field.

Hopefully I have made my problem clear and someone out there has a suggestion for how to get this right.

Thanks!