Previous Previous Month Sale using SetExpression Help

[kakani87]

Hi Folks,

I want to show previous previous month sale

The following expression is for previous month and tried using -2 instead -1 this is showinng the previous month sale only

Any help regarding this

sum

(

{<

CalendarMonthAndYear={'$(=DATE(Max(CalendarMonthAndYear)-1,'MMM YYYY'))'}

>}

sales_total

)

Regards,

Kishore.

[prma7799]

Try like this

=SUM({$<MonthName=, [Posting Date]={">=$(=MonthStart(max([Posting Date]),-2))<=$(=(addmonths(max([Posting Date]),-2)))"}

>}[Gross Sales Amount])

[tresesco · Accepted solution]

Try like:

sum

(

{<

CalendarMonthAndYear={"$(=DATE(AddMonths(Max(CalendarMonthAndYear),-2),'MMM YYYY'))"}

>}

sales_total

)

[kakani87]

Thank you Tresesco