Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
If you simply want the number of weeks you selected try =getselectedcount(WeekNo)
If you simply want the number of weeks you selected try =getselectedcount(WeekNo)
I knew there was a simpler way ...I just couldn't find it!
Many thanks, that worked a treat.