Last months sale

[Anonymous]

Hi All,

Using below am getting last year Last month sale (28-FEB-16) but am not getting  29-feb-16 day of sale.

What i want to make changes in this

Thanks

[tyagishaila]

to get 29 feb 16 you have to use MonthEnd().

for better understanding share sample data and required output.

[tresB · Accepted solution]

Try like (change highlighted in red):

(SUM({$<FinancialYear=,MonthName=,FiscalYear={$(=max(FiscalYear)-1)},Quarter=
,[Posting Date]={">=$(=MonthStart(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]),-12))<=$(=MonthEnd(addmonths(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]),-12)))"}
>}[Gross Sales Amount])