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!!!