One of the customer wants to calculate True NPS Score(%Promoters - %Detractors) for a particular survey. They wanted to calculate the NPS Score based on region field. They have different regions and they wanted to calculate NPS differently based on the region.
They wanted to build a report and show this True NPS Score in it. I tried building report on survey flattened object and couldn’t find a way to achieve this request using formula field in report builder.
With the current functionality I couldn’t find a way to achieve it directly. Has anyone come across this request and implement earlier ? Any thoughts on how we can achieve it ?
Best answer by sekhar_duttaView original