1 2 Previous Next 17 Replies Latest reply on Nov 1, 2016 10:24 PM by sneha simha

    Mtd formula

    sneha simha

      M using this formula for calculating MTD TY

      if [Date]>=DATEADD('day',-DAY(TODAY()-1)+1,TODAY()-1)

      and

      [Date]<=TODAY()-1 then [Net Value] end

       

      But my problem is i have data From April 2016 till august 2016.Can anyone help me in fetching Data for August month TY and Last year also with YTD TY and YTD LY.

       

       

      Thanks and Regards

      Sneha

        1 2 Previous Next