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: