2 Replies Latest reply: Sep 7, 2017 12:18 PM by Stephen Hasson RSS

    Problem with conditional logic

    Stephen Hasson

      Hi, in the attached, field ‘%-age of Total Hrs’ is correct, e.g.  14.78/1040.37*100 = 1.42%

       

      For the figures shown (examples in yellow), I want to express the value of labour hours as a percent of the Indirect or Productive hours respectively (ie 1040 is a combination of 200 ‘I’ and 840 ‘P’ hours.

       

      So, I need to combine some conditional logic in the calculation of these percentage. I’ve tried:

       

      Sum([Labour Hrs])/Sum({$<[Labour Type]={'I'}>}(TOTAL([Labour Hrs]))*100

       

      and some variations, but I can’t get the combination of TOTAL and the conditional function to work.

       

      Can anyone please help, thanks.