2 Replies Latest reply on Jul 7, 2016 11:02 AM by Manideep Bhattacharyya

    Counting and Finding sum of combination of Dimensional attributes

    amulya.sharma

      Hi everyone,

       

      I got a field in Excel:

      Treament Status  

      IT
      IT
      SD
      USD
      SD
      SD
      USD

      I need to use a calculated field to find a Percentage of total using this mathematical formula, based on the number of times certain dimensional attributes appears in the column i.e. Count:

      % of R = [Count(SD)+Count(IT)]/[Count(Total of everything in Treatment Status)]

      I know how to use the COUNT and SUM functions but I'm trying to connect the dots here.

      Thank you!