Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
=GetSelectedCount(Month)
use GetSelectedCount() function.
=GetSelectedCount(months)
=GetSelectedCount(Month)
Month & '( ' & GetSelectedCount( Month) & ')' will give you count of selected Months
Regards
Chaitanya
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
=GetSelectedCount(months)
Wow, thanks so much for all your replies