Selected Months or Days

[#1]

Good day.

i am hoping that someone could point me in the right direction.

i have list boxes with Years, Months and Days. i need to determine if there are any months or days selected and how many are selected.

i have the following expression

Count(DISTINCT([Month]))

Count(DISTINCT([Day]))

if there are any months or days selected it gives me the correct count, but if none are selected it gives me the full count (eg. 12 months if none are selected)

how can i determine if any months or days are selected?

any help would be appreciated.

[kaushiknsolanki · Accepted solution]

Hi,

Try this functions.

Getselectedcount(FieldName)

GetPossibleCount(FieldName)

Regards,

Kaushik Solanki

[#3]

Thank you so much Kaushik.

That is perfect.

Thank you so much for taking the time to help me.

[kaushiknsolanki]

Its a pleasure...

Regards,

Kaushik Solanki