Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have the following expression which returns data for the current month
sum({<[Issue Date]={'>=$(=monthstart(today()))<=$(=monthend(today()))'}>}Sales)
I also need 2 more expressions, 1 to return data for last month and 1 to return data for next month.
Can anyone help please?
previous month: sum({<[Issue Date]={'>=$(=addmonths(monthstart(today()),-1))<$(=monthstart(today()))'}>}Sales)
next month: sum({<[Issue Date]={'>$(=monthend(today()))<=$(=addmonths(monthend(today()),1))'}>}Sales)
previous month: sum({<[Issue Date]={'>=$(=addmonths(monthstart(today()),-1))<$(=monthstart(today()))'}>}Sales)
next month: sum({<[Issue Date]={'>$(=monthend(today()))<=$(=addmonths(monthend(today()),1))'}>}Sales)