Set Analysis Max Month Year

[jonathanrichey]

Is it possible to nest a set analysis with the Max month and year?

Current set Analysis (working):

(sum({<PeriodType={'Rolling 12'}>}MonthYear_Flg))

Desired:

When adding the Max function the syntax returns an error in the expression:

(sum({<PeriodType={'Rolling 12'}, Max(AsOfDate)>}MonthYear_Flg))

[dplr-rn · Accepted solution]

sure. in your expression

add

MonthYear={"$(=max(MonthYear))"}

or MonthYear={"$(=date(max(AsOfDate), 'MMM-YYYY'))"}

or if you dont have a master calendar

AsOfDate={">=$(=monthstart(max(AsOfDate)))"}  // just great or equal to first of the month

[jonathanrichey]

Awesome! Thanks for the response Dilip!

[dplr-rn]

no problems