Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Test
Hi
This should work (change the field names to match your model):
Count({<Year = {'$(=Max(Year))'}>} Distinct Month)
Max(Year) will return the last year on file, if nothing is selected, or the selected year if one is selected.
HTH
Jonathan
if(GetFieldSelections(Year) = year(today()), SubField(today(),'/',1),12)