Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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,
that's exactly what I thought but wait I will show you something...