4 Replies Latest reply on Apr 1, 2016 1:47 PM by Anne Laverick

    Prior YTD Calculation

    Anne Laverick

      I am trying to bring in the Prior Year YTD sales into the report, yet all I am getting with this remaining sales for the year and not the sales for the 1Q of last year. Below is my formula

       

      If DATEDIFF('month',[Month],Today())=13 AND DATEDIFF('month',[Month],Today())=24 THEN [Sales] END