cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JanMuller Frequent Visitor
Frequent Visitor

Re: Trying to calculate NPS (Net Promoter Score) via custom calculated column

It's weird. For a long time this worked fine but now all my reports say: "The syntax for '"Detractors"' is incorrect." Any chance someone knows what's going on?

JanMuller Frequent Visitor
Frequent Visitor

Re: Trying to calculate NPS (Net Promoter Score) via custom calculated column

It's weird. For a long time this worked fine but now all my reports say: "The syntax for '"Detractors"' is incorrect." Any chance someone knows what's going on?

Highlighted
sefanja Frequent Visitor
Frequent Visitor

Re: Trying to calculate NPS (Net Promoter Score) via custom calculated column

Based on your formula, I've created an alternative that handles blanks correctly in the case where there are only Passives and no Promoters or Detractors.

 

NPS Score =
  VAR ResponseCount = COUNTA(SurveyResponse[Answer])
  VAR PromoterCount = COUNTAX(FILTER(SurveyResponse, [Answer] >= 9), [Answer])
  VAR DetractorCount = COUNTAX(FILTER(SurveyResponse, [Answer] <= 6), [Answer])

  VAR Score = 0 + (PromoterCount - DetractorCount) / ResponseCount * 100

  RETURN IF(NOT(ISBLANK(ResponseCount)), Score)

 

BruceRudd Frequent Visitor
Frequent Visitor

Re: Trying to calculate NPS (Net Promoter Score) via custom calculated column

I've been using this and it does give me the correct NPS score but as I looked at the filter again today wouldn't it be filtering out all the '0' scores that were given from the NumOfRespon?  As the NPS scale is 0-10, 0 is a valied response that should be included.