I'm doing a report that requires:
Employee, Hours Worked, Pay Received, VacationPay, Dues
I have several formulas to get the totals to work on the Group Footer as the Hours Worked and the Pay Received are repeated in the detail. So, I did a count on those fields and divided my total by the count. Now I'm trying to get a total of the caculated field in the Report Footer, but it won't let me and
when I copy it down, the formula doesn't work. I need to grab the result of the calculation in the total and sum it at the bottom of the report.
The data looks like this:
Employee Name; Count; Hours, Pay, Vacation, Dues
John Smith 0 0 0 0 50.00
1 40 100 25 0
1 40 100 10 0
Group Total 2 80/2 200/2 35 50
I have an if statement for hours and Pay which returns the amount if the vacation field is populated. However, some employees have two entries for Vacation and so the hours are shown twice.
Employee, Hours Worked, Pay Received, VacationPay, Dues
I have several formulas to get the totals to work on the Group Footer as the Hours Worked and the Pay Received are repeated in the detail. So, I did a count on those fields and divided my total by the count. Now I'm trying to get a total of the caculated field in the Report Footer, but it won't let me and
when I copy it down, the formula doesn't work. I need to grab the result of the calculation in the total and sum it at the bottom of the report.
The data looks like this:
Employee Name; Count; Hours, Pay, Vacation, Dues
John Smith 0 0 0 0 50.00
1 40 100 25 0
1 40 100 10 0
Group Total 2 80/2 200/2 35 50
I have an if statement for hours and Pay which returns the amount if the vacation field is populated. However, some employees have two entries for Vacation and so the hours are shown twice.