5 Replies Latest reply on Apr 21, 2017 5:19 AM by Y Mani

    MTD Calculation

    Y Mani

      Hi,

       

      I have tried using YTD and MTD Calculation as below, but MTD doesn't work

       

      IF [Order Date] <= TODAY()

      AND DATEDIFF('month',[Order Date],Today())= 0 THEN [Sales] END

       

      IF [Order Date] <= TODAY()

      AND DATEDIFF('month',[Order Date],Today())= 0 THEN [Sales] END.

       

      Please can any one help me on this

       

      Thanks