Discussion board where members can learn more about Qlik Sense Data Connectivity.
I've this data:
I would like to calculate the NPS score which formula is = ((Promoters - Detractors)/ TOTAL(CountDistinctSurvey))*100
Where I created a new column Promoters = IF (tnps_global_nps_segment_alt = 'Promoters', CountDistinct_surveyid, 0)
and Detractors = IF (tnps_global_nps_segment_alt = 'Detractors', CountDistinct_surveyid, 0)
I am not able to get the TOTAL(CountDistinctSurvey). I am totally new to Qlik Sense.