Count number of values selected

[#1]

Hi

I have a selection field that shows the months (Jan - Dec).

I would like to find out, how many months have been selected.

If I use 'Count(Distinct Month)' then I do get the number of selected months, but I also get 12 if there is no month selected. How can I adjust the count to find out if there are none selected?

Thanks

[senpradip007]

use GetSelectedCount() function.

[rubenmarin]

GetSelectedCount is the function you are searching.

getselectedcount(NombredeCampo [, IncluirExcluidos])

[MK_QSL]

=GetSelectedCount(months)

[anbu1984 · Accepted solution]

=GetSelectedCount(Month)

[ychaitanya]

Month & '( ' & GetSelectedCount( Month) & ')'  will give you count of selected Months

Regards

Chaitanya

[PrashantSangle]

Hi,

You can use GetSelectedCount(Month)

Logically when no month is selected then you are getting data of all months therefore It means you have all available month to count.

So try GetSelectedCount() instead of count(Distinct Month)

Regards

[#8]

=GetSelectedCount(months)

[#9]

Wow, thanks so much for all your replies