9 Replies Latest reply on Jan 13, 2019 8:16 AM by Paul Wachtler

    Calculate the percentage by FIXED

    Dinh Hoang

      Hi

      I'm a newbie

      I have an excel file below:

      I want to calculate the percentage: 0 <= Hour <= 24 / total hours (similar: 24<Hour<=48 , 48<Hour<=72)

      by group [Sub-category] and [Warranty staff]

      I created 2 calculated fields:

      a = IF [Hour]> 0 and [Hour] <= 24 THEN {FIXED [Sub-category], [Warranty staff]: COUNT ([Hour])} END

      b = COUNT ([Hour])

      I took a/b but falied

      Capture.PNG

       

      Looking forward to early feedback from everyone!

      Thanks