Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to get previous month sales for the current year. In my table YEAR,MONTH,SALES are there. MONTH format is 'MMMYY'.
please help me to write set analysis for sum of sales of previous months.
Thanks in advance.
try this
Sum({<Month = {"$(=Date(MonthStart(Max(Month), -1), 'MMMYY'))"}>}Sales)
I think you might need to use Inter-Record Functions here
Hi Arvind ,
Thanks for reply but this code not working.
Hi,
Kindly provide me sample data so i can give you exact op.
Thanks & regards,
Arvind Patil
Year Month Sales
2017 Sep17 300
2017 Oct17 340
2017 Nov17 345
2017 Dec17 674
2018 Jan18 235
2018 Feb18 564
In A text object i want to display previous month Sum of sales .
it will be 235
try this
Sum({<Month = {"$(=Date(MonthStart(Max(Month), -1), 'MMMYY'))"}>}Sales)
Thanks sunny. its working now.