I am creating a timesheet report and have managed to group by employee and job number then split our the hours value across the days of the week using a formula which sums the decimal hours per day. it looks like this:
Employee - T Smith Week Commencing: xx:xx:xxxx
Job no: MON TUES WEDS THURS FRI
E05515 2.5 0.0 3.5
EN5623 1.5 2.0 0.0
And so on.... the calculated hours for each day are on a formula which checks the day of the job records (there can be more than one detail line for a single job) and sums them.
My problem is that I need to add up all the values for MON at the bottom in the employee group, but CRYSTAL wont let me sum the summed formula field... I have tried running totals and trying to pull out the details again at employee level - but nothing seems to work... any ideas?