Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
=Floor(Sum({<Year={"$(=Year(Max(Date))-1)"}, Date= {"<=$(months(max(Date)))"}>} arqtyshp)).
Hi
Use MonthStart and MonthEnd Function
Like
=Sum({<Date = {'>=$(=MonthStart(Max(Date))) <= $(=MonthEnd(Max(Date)))'}>}Sales)
Hope that helps
=Floor(Sum({<Year={"$(=Year(Max(Date))-1)"}, Date= {"<=$(months(max(Date)))"}>} arqtyshp)).