Skip to main content
I am capturing and trying to calculate NPS (Net Promoter Score) in Salesforce. I have an existing report that tells me if the NPS provided in the survey is a promoter or distractor, but the result of my calculation on the report formula is a percentage, not a whole number (which is should be).

 

NPS is calculated by taking the percentage of promoters minus the percentage of distractors. While this seems easy to calculate, I can't seem to get it to work on a report formula.

 

I have tried updating the output type from percentage to number on the report forumula, but it returns nothing (not even a zero). No result shows at all. Here is a screenshot of my formula (this one has the percentage as the result).

 

NPS Calculation in Reports
1 个回答
  1. 2014年10月21日 16:34
    Can you post a screenshot of the Report results and how you have the results Grouped?  

     

    Are you using the Power of One on those objects?  
0/9000