2 Replies Latest reply: Sep 26, 2012 2:47 AM by Rajni Batra RSS

    MTD

    Renjith Kumaran

      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