I'm using Crystal Reports XI
Let me start with the required output...
Employee Name Regular Hours OT Hours Total OT Percent Variance
Store #1
Hourly
Alex Abrams 2.75 0.00 2.75 100.00% (a) 58.68 <-- a-b
Bill Brown 250.00 1,477.75 1,727.75 14.47% (a) -26.85 <-- a-b
Chris Carter 59.00 563.25 622.25 9.48% (a) -31.84 <-- a-b
Totals for Hourly: 311.75 2,041.00 2,352.75 41.32 (b)
Totals for Store #1:
First things first, there is no "detail" section in the above. The "Employee Name" rows are actually Group 3 (with totals summarized for Regular Hours, etc.). Group 2 is "Pay Type" (Hourly shown, there is also a Salary that is not shown, but will still be calculated in the same way). And "Store #" would be Group 1
What I'm looking for is a calculation for the Variance. Basically for each row it's the value of the OT percent for that row (a) minus the average of all the values for OT percent for Group 2. (b)
So, any ideas on how I can do this? I have tried doing a calculation but received an error that the OT value (a) cannot be summed.
TIA