I have a survey web form. One of the questions is "likelihood to recommend" with a dropdown list of 0 - 10. I'm trying to build a report from this web form that will automatically calculate the net promoter score (% promoters (9&10s) - % detractors (0-6s)). I know how to build the formulas to calculate these, but I don't know how to build them so that the stats automatically adjust as surveys automatically come in. Can this be done? And if so - how? Any help would be appreciated.
