Skip to Content
0
Former Member
Nov 12, 2012 at 08:06 PM

Calculating Based On Sum of Groups

32 Views

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