We need to create a formula field called NPS score, which displays the result of Some survey. Goal being having a report displaing this key metric for the survey.
This formula is based on the response type that you can find below :
Response Category: - (17 records)
Response Category: Detractor (35 records)
Response Category: Neutral (61 records)
Response Category: Promoter (44 records)
NPS score = % of (Response Category= Promoter) - % of (Response Category= Detractor).
For the calculation of the promoter or detractor percentage, do not forget to include the response category=neutral in the total (number of promoters/ total promoters, neutral, detractor).
Note: Response Categary is a picklist field containing Promoters,detractors and Neutral as the picklist values .
Could you please help me in how to proceed with this.......
Thanks in advance ....
kantha
3 answers
So do you have roll up summary fields for the Response categories?
