6 Replies Latest reply on Feb 29, 2016 12:57 PM by Suresh Sridharan

    Percentage calculation

    Suresh Sridharan

      Hi,

      I would like create a % calculation on Reliability indicator. Count of X divided by no. of records on the category, subcategory combination

      CategorySub categoryReliability indicator
      AA1X
      A1
      A1X
      A5
      A5
      BB1
      CC2X
      C2X
      C2X
      C2X

      Desired output:

      CategorySub-category
      Reliabilty %
      AA166.6%
      A50%
      BB10%
      CC2100%

       

      Appreciate your help.