Expression not working -sum({<MonthYear={">=$(addmonths(max(PM_YearMonth),-5))<=$(addmonths(max(PM_YearMonth),0)"}, FiscalYear=,FiscalMonth=>}PM_Actual)

[#1]

Hi all,

I am facing issue with the expression. It's not working.

It basically calculating previous 6 months actuals

Thanks

[Kushal_Chawda · Accepted solution]

I think you are missing ')'

=sum({<MonthYear={">=$(addmonths(max(PM_YearMonth),-5))<=$(addmonths(max(PM_YearMonth),0))"}, FiscalYear=,FiscalMonth=>}PM_Actual)

[sunny_talwar]

You might need another parenthesis at the end:

-sum({<MonthYear={">=$(addmonths(max(PM_YearMonth),-5))<=$(addmonths(max(PM_YearMonth),0))"}, FiscalYear=,FiscalMonth=>}PM_Actual)'

[Gysbert_Wassenaar]

Try sum({<MonthYear={">=$(=addmonths(max(PM_YearMonth),-5))<=$(=max(PM_YearMonth))"}, FiscalYear=,FiscalMonth=>}PM_Actual)

[Anonymous]

Hi,

I think you need to use single quotes.

eg:

sum({<MonthYear={'>=$(addmonths(max(PM_YearMonth),-5))<=$(addmonths(max(PM_YearMonth),0))'}, FiscalYear=,

         FiscalMonth=>} PM_Actual)