Hi
I am trying to find a correct formula syntax to calculate NPS score (Net Promoter Score).
I know how the formula goes in paper but I can't figure out the correct syntax to place in the custom calculated column.
Below I will write the calculation. I would appreciate if someone could help me to find the correct formula syntax.
I have a column that contains grades given by customers from 0-10. There may be some row's where there is no grade and these row's should not be in the overall calculation.
NPS Score Calculation:
Example: If you received 100 responses to your survey:
10 responses were in the 0–6 range (Detractors)
20 responses were in the 7–8 range (Passives)
70 responses were in the 9–10 range (Promoters)
(Number of Promoters — Number of Detractors) / (Number of Respondents) x 100
When you calculate the percentages for each group, you get 10%, 20%, and 70% respectively.
To finish up, subtract 10% (Detractors) from 70% (Promoters), which equals 60%. Since an example Net Promoter Score is always shown as just an integer and not a percentage, your NPS is simply 60. (And yes, you can have a negative NPS, as your score can range from -100 to +100.)
