I using a formula to allow me to work out the the NPS score, which is SUM(@D:D-@E-E)/COUNT(@C:C)*100 (D= Promoter, E=Detractor, C=Net Promoter). This all works perfectly. However, when I try to use the User Input Control to filter the subregion, it fails to work.
The user input control works for all my other Klips, just not the NPS one, as this is the only one that is based around a formula.
I have tried SUMIF, SELECT, GROUP, etc, but nothing seems to work.
Any help would be greatly appreciated.