Last Month Expression

hopkinsc — Thu, 15 Aug 2013 08:59:37 GMT

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?

Re: Last Month Expression

Gysbert_Wassenaar — Thu, 15 Aug 2013 09:03:35 GMT

previous month: sum({<[Issue Date]={'>=$(=addmonths(monthstart(today()),-1))<$(=monthstart(today()))'}>}Sales)

next month: sum({<[Issue Date]={'>$(=monthend(today()))<=$(=addmonths(monthend(today()),1))'}>}Sales)