Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try with
=Sum({<MonthName={'$(=Date(AddMonths(MonthName,-1),'MMMYY'))'}>} SALES)
Hi
try this
Sum({<MonthName={"=$(=Date(AddMonths(max(MonthName),-1),'MMMYY'))"}>} SALES)
Also check your 'Monthname' format
Try with
=Sum({<MonthName={'$(=Date(AddMonths(MonthName,-1),'MMMYY'))'}>} SALES)
Thanks it works