Counting number of selectors, including those with null values
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:
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.