Set Analysis

[#1]

Hi All,

I am getting not getting a desired result withe below expression

=Sum({<MonthName={"=$(=Date(AddMonths(MonthName,-1),'MMMYY'))"}>} SALES)

It shows an 0 sales which is not true .

I want to sum the sales for the previous month, here MonthName is the current month .

Can anyone please help ?

Thanks

Shivaj

[Anonymous]

Hi

try this

Sum({<MonthName={"=$(=Date(AddMonths(max(MonthName),-1),'MMMYY'))"}>} SALES)

Also check your  'Monthname' format

[stigchel · Accepted solution]

Try with

=Sum({<MonthName={'$(=Date(AddMonths(MonthName,-1),'MMMYY'))'}>} SALES)

[#4]

Thanks it works