Counting number of selectors, including those with null values

[ljackson]

I'm trying to create an expression to show the number of weeks that have been selected.   I have selected weeks 11, 12, 13 and 14, but when trying to count the total number of weeks selected (using 'count distinct') the result comes back as 2 as there are null values in 2 of the selected weeks.

One of the expressions I have tried to use (to get an answer of 4) is:

count(DISTINCT WeekNo) + (count(distinct(IsNull(WeekNo)))

Clearly I've got this wrong, but can't seem to work out how to correct it.  Has anyone else done this?  All I really want to know is the total number of selections, regardless of whether there are data entries or null values.

Many thanks.

[Gysbert_Wassenaar · Accepted solution]

If you simply want the number of weeks you selected try =getselectedcount(WeekNo)

[ljackson]

I knew there was a simpler way ...I just couldn't find it!

Many thanks, that worked a treat.