Calculating NPS scores in Qlik SEnse

[nani__87]

Hi all,

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.