NPS Promoter Percentage Formula Help

Question & Answer
, ,
1

Hey everyone. I am trying to find the percentage of “Promoters” for an NPS calculation and keep getting errors. The formula I’m using is:

(countIf({Most Recent NPS Rating} = "10", OR {Most Recent NPS Rating} = "9")/count({First Name}))

All I’m trying to do is count the NPS rating column if the number in it is greater than 9 or 10 and then divide that number by the count of the first names to get the total number of respondents. Any help will be greatly appreciated

2

Hey @Tj39 ,

could you try:
countIf({Most Recent NPS Rating}, {Most Recent NPS Rating} = “10” OR {Most Recent NPS Rating} = “9”)/count({First Name}))
Countif needs two attributes and you don’t need a comma in front OR.

BR
Robert

2 Likes