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