1 2 Previous Next 15 Replies Latest reply on Feb 3, 2017 6:04 AM by Vincent Baumel

    what i am missing in this ytd,mtd

    msa s

      unable to see values for ytd,mtd

       

      any suggestions ?

       

      mtd

       

      IF [Order Date]<=TODAY()

      AND DATEDIFF('month',[Order Date],TODAY())=0

      THEN [Sales]

      END

       

      even if i change it to 7 also it didnot work

       

        1 2 Previous Next