AnsweredAssumed Answered

Calculation issue

Question asked by gjbdjc on Aug 28, 2014
Latest reply on Aug 28, 2014 by philmodjunk


Calculation issue


     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?