This content has been marked as final. Show 3 replies
I have a table that is displayed below. I am calculating each weeks overtime hours and std hours
Std hours formula:
if(sum(laborhrs)-(40*count(empid))<0 , 0 , sum(laborhrs)-(40*count(empid)))
emp count column:
if(Dimensionality()=0, count(all empid),count(empid))
My issue that I am running into is the total. I need to see the sum of the values. the issue is that the portion count(empid) is returning the wrong number (Should show 446).
How do I tell this to take the sum of the above for the total?
week std OT emp count