Help me understanding this set analysis expression...

[kartik]

Hi Everyone!!

Here is the Set Expression used in a sheet and I'm not able to understand this TLmonth Expression. Pls help

Count({<[Calendar Year]={$(=Max([Calendar Year]))},TL_MonthNo={$(=Max({<[Calendar Year]={$(=Max([Calendar Year]))}>}TL_MonthNo))},
Flag={'servicePSF'}>}FLMS_CUST_NO)

Thanks in advance.

[vinieme12]

TL_MonthNo={  $(=Max({<[Calendar Year]={$(=Max([Calendar Year]))}>}TL_MonthNo)) }

This will return all possible TL_MonthNo values where [CalendarYear] = max([CalendarYear])

This is however redundant, since [Calendar Year] is already filtered to its max value, applying the same condition filter on TL_MonthNo is unnecessary,

[kartik]

that's exactly what I thought but wait I will show you something...