Calculate weighted NPS

[nmck86]

Weighted NPS calculation help.. how to incorporate.

[Greg_Deckler]

Can you just create a new column that is [Value] * [Weights]?

[nmck86 · Accepted solution]

was finally able to figure this out by summing the weights and then doing my calculation as normal

[Ashish_Mathur]

Hi,

Your second link is not working.  I have downloaded your PBI file but cannot understand the result you want there.  Show clearly the numbers that you are expecting and the method of calculating those number.

[nmck86]

Resolved! Thanks for the assistance.

[Ashish_Mathur]

Hi,

I have got the first answer correct but not the second one.  Someone else will help you.  Download the file from here.

[nmck86]

That method distorts NPS

[nmck86]

Here is a sample of the data in a better format and the excel file with the original formula.

[nmck86]

Here is a sample of the data in a better format and the excel file with the original formula.

[nmck86]

I can't.. I will share a file with you in just a few minutes. Essentially, the weight is based on the unique response ID instead of the actual answer on the survey. For instance, each unique id is counted once "typically" however, we have weighted each respondent and for that they may be only classified at a weight of .70 instead of 1 for instance.

[nmck86]

Below is a link to a sample file with dummy data for an example... you will notice that i have built a formula already that gives me the % of promotors detractors and passive survey takers... however, the NPS score based on the weight is stomping me. I would normally just do a simple divide for promotors, detractors, and passive but in this case the weight is not taken into consideration.

https://drive.google.com/open?id=14S4YG2X80ueSp3tMl0wqnBVUXfvIfJ0P