3 Replies Latest reply on Nov 21, 2016 4:28 PM by Eamon Maher

    String value percent of total

    Eamon Maher

      I have been trying to find a solution for this. I have a field I want to count the string of certain values and get the percent of the total. I can't figure out a formula that works.


      I essence, I want to count how many times 'The brand name' Comes up and figure the percentage of that against all the records.


      This is the formula that I have so far that is wrong but I can't can't figure out another way to do it.

      COUNT([Reason] = 'The brand name') / Total([Reason])


      Thank you all for your help.