MTD

[#1]

This is my equation for YTD

=Floor(Sum({<Year={"$(=Year(Max(Date))-1)"}, Date= {"<=$(=addmonths(max(Date),-12))"}>} arqtyshp)).

Anybody colud tell me how to make it as MTD.

Thanks in Advance

[MayilVahanan]

Hi

Use MonthStart and MonthEnd Function

Like

=Sum({<Date = {'>=$(=MonthStart(Max(Date))) <= $(=MonthEnd(Max(Date)))'}>}Sales)

Hope that helps

[rajni_batra · Accepted solution]

=Floor(Sum({<Year={"$(=Year(Max(Date))-1)"}, Date= {"<=$(months(max(Date)))"}>} arqtyshp)).