Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Trying to calculate the efficiency of employees based on their individual actual production and time and the target for 7 hours. I have not problem to get this for each employeeagainst their individual actvity. But for obvious reasons, the employee efficiency for all the activities is an incorrect answer. Can someone help please. Sample attached.
Nimish
Hi Nimish,
If I understand the issue correctly then your problem is the totals.
Try changing the expression (nr 3 - Equated for 7 hours) to: sum(aggr((Sum(Volume)/(Sum(TimeTaken)*24)*7), Name, ActivityName))
Also change the last expression to: sum(aggr((Sum(Volume)/(Sum(TimeTaken)*24)*7), Name, ActivityName))/(Sum(TargetVol))
Hi Nimish,
If I understand the issue correctly then your problem is the totals.
Try changing the expression (nr 3 - Equated for 7 hours) to: sum(aggr((Sum(Volume)/(Sum(TimeTaken)*24)*7), Name, ActivityName))
Also change the last expression to: sum(aggr((Sum(Volume)/(Sum(TimeTaken)*24)*7), Name, ActivityName))/(Sum(TargetVol))
Hi Johannes,
Thank you for the quick solution. I am travelling just now but will use this in the production tables (there are lot of set modfiers also) and check this. I think this should work but will confirm and verify the answer once I have tried it on the actual tables.
Nimish