Skip to Content
0
Former Member
Feb 08, 2011 at 08:48 PM

This field cannot be summarized

679 Views

I have a report where I need to calculate a total number of hours for the day and then for the week for each employee. When trying to calculate the weekly total, I get an error message that says 'this field cannot be summarized'. Below is the formula for the field that I am trying to summarize:

If {@ActHrsWorked} < 5.00 then {@ActHrsWorked} else

If {EMPLOYEE.SHIFT_ID} ='NO PARAMETERS' then {@ActHrsWorked} else

If {EMPLOYEE.SHIFT_ID} = 'OFFICE' then {@ActHrsWorked} else

{@ActHrsWorked} - .5

The @ActHrsWorked formula is as follows:

DateDiff ("n",Minimum ({Command.CLOCK_IN}, {Command.SHIFT_DATE}, "daily"), Maximum ({Command.CLOCK_OUT}, {Command.SHIFT_DATE}, "daily")) / 60

My employees clock in on labor tickets and can be clocked in on more than one at a time thus the need for the Minimum Clock_In and Maximum Clock_Out.

Please let me know if I can provide any more information. Thank you in advance for your help!!!