How to calculate count of months(Number of months) dynamically.

[dhananjay_capge]

Test

[jonathandienst]

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

[Anonymous]

if(GetFieldSelections(Year) = year(today()), SubField(today(),'/',1),12)