Calculating NPS total score based on a survey
Hello, I need to create an NPS score calculation. I know the formula ( [ (No. of promoters - No. of detractors) / Total responses ] * 100), but whenever I enter into a beast mode calculation, it does not work.
How do I need to format my survey information data, or write my formual to get the card to aggregate correctly and display the NPS score?
The data format I currently have is pasted below. Here is the beast mode calculation I've tried:
((sum(`Promoter Count`) - sum(`Detractor Count`)) / sum(`NPS Count`))*100