I'm creating a report for production totals.
I have production lines that may have 1,2 or 3 operators at any given time. I have the following calculations:
Operator 1 hours + Operator 2 hours + Operator 3 hours = Shift Labor Hours
Summary Field of Shift Labor Hours = Total Shift Labor Hours
I want to get my total Pounds Produced per Labor Hour, but when I divide Total Good Pounds / Total Shift Hours
I get a crazy number, looks like it's giving me the grand total number?