I am trying to total the FLSA Cash for all of the pay weeks for one employee (group) above. FLSA Cash is a calculated fields using AVG([Work Week]), SUM([OTCASH], SUM([OTCOMP]), SUM([LEAVE]) and AVG([Hourly])
I believe that I may have to setup a query to do the calculation, but how do I do that with fields from the report?
I also want a grand total for all employees at the end of the report. I think if I get past the first calculated field issue, everything else will fall into place.
the report is grouped by employee then by pay week. HELP!
I believe that I may have to setup a query to do the calculation, but how do I do that with fields from the report?
I also want a grand total for all employees at the end of the report. I think if I get past the first calculated field issue, everything else will fall into place.
the report is grouped by employee then by pay week. HELP!