cancel
Showing results for 
Search instead for 
Did you mean: 

Webi; Count Distinct variables in a column.

Former Member
0 Kudos

I'm trying to create a variable that will tally the total number of unique variables in a column. For example, based on the below ICD10 codes, the variable would display Z02.9 (4), F32.9 (4), etc. I tried using =Count([Diagnosis Code];Distinct) but that only yields a tally of 1 for each row. Any help greatly appreciated. Thanks.

Z02.9
Z02.9
Z02.9
Z02.9
Z00.00
F32.9
F32.9
F32.9
F32.9
F43.10
F43.10
F43.10
G47.9

Accepted Solutions (0)

Answers (2)

Answers (2)

amitrathi239
Active Contributor
0 Kudos

try this.

=Count([Diagnosis Code]) in ([Diagnosis Code])

0 Kudos