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

# String value percent of total

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.

• ###### 1. Re: String value percent of total

Without testing on my end :

// exact match

sum(if [Reason] = 'The brand name' then 1 else 0 end)/total([Reason])

OR

//wildcard match

sum(if find([Reason],'The brand name') > 0 then 1 else 0 end)/total([Reason])

• ###### 2. Re: String value percent of total

Hello Eamon

I essence, I want to count how many times 'The brand name' Comes up

For this thing, I am attaching a Workbook which will clearly show you how to count the occurance of particular words!

once this count is there, just calculate the percent of total.