I have a report that shows all individuals on a shift and how well they do their daily jobs. At the bottom of the report it displays the overall daily average taking into account all the individual scores of the associates.
Their are three percentage scores that the person gets per day. Performance, Utilization, and efficiency. their are three elements that go into calculating those scores.
paid time ( time on the clock)
Earned time ( how long it should have taken to do the work) and
Productive time ( paid time - lunch, break, and other times no work is being done)
Performance is earned time / Productive time
Utilization is productive time / paid time
Efficiency is performance * utilization
sorry I had to go through all that but it is important to know where the numbers come from.
at the bottom of the report is a overall daily average of all associates. The problem I am having is that the first way I set it up is not really giving me a true average of the day. I created three unbound boxes in the report footer and had them simply sum all the individual paid time, earned time, and productive times. I then calculated the daily top three just like i do the individual people. This does not however take into account 0%. the sum ignores the 0.
Daily performance (=[sumearned]/[sumproductive])
Daily Utilization (=[sumproductive]/[sumreported])
Daily Efficiency (=[AvgOfPerformance]*[AvgOfUtilization])
the report it generates
I copied the report and changed it to simply average the daily performance and the other two and it not only changed what was displayed in the report footer but in the main report as well.
what I changed.
Daily Performance (=[Avg Of AvgOfPerformance])
Daily Utilization (=[Avg Of AvgOfUtilization])
Daily Efficiency (=[AvgOfPerformance]*[AvgOfUtilization])
the report it generates
For some reason changing the calculations in the report footer also changes the last associates record and throws off the daily average. Namely Vation, Billy goes from 124% to 0%. Why are those calculations being effected?