Reverse Calculate Net Promoter Score to provide survey breakdown

[JPG963]

I have a result for net promoter score and also have the amount of surveys taken. I need to find how many promoter, passives, and detractors make up that score. Here is how the net promoter score is calculated - Each promoter counts as a 100, each passive counts as 0, and each detractor counts as -100. All Promoters are added up then subtract the total detractors then divide by surey count (Promoter total - Detractor total / sample size = NPS result). My problem is I need to break down in reverse without knowing the amount of promoters, passives or detractors received. Only have the result and survey count. Can someone assist with a formula to calculate amount of promoters and detractors based on the info I have? Any help would be appreciated as I have been racking my brain on this for a while.

 

[Fluff]

Can someone assist with a formula to calculate amount of promoters and detractors based on the info I have?

Not really. If you look at the score of 25.00 with 4 surveys, it could be 1 promoter & 3 Passive, or 2 Promoter, 1 Passive & 1 Detractor

 

[JPG963]

Not really. If you look ate the score of 25.00 with 4 surveys, it could be 1 promoter & 3 Passive, or 2 Promoter, 1 Passive & 1 Detractor

Another form of calculation is (%promoter-%detractor=NPS). My ultimate need is to provide a total for that data in the image above. Average will not be correct dur to weight of each cell based off amount of surveys. Any way to average NPS column based on weighing the survey count?

 

[Fluff]

Not sure what you mean by

Another form of calculation is (%promoter-%detractor=NPS)

There must be a set way of calculating the score. However, regardless of how it's calculated I doubt you can figure out what the original results were as I pointed out in post#2