6 Replies Latest reply on Jun 23, 2014 12:42 AM by praveen p

    YTD sales

    praveen p

      Hi all,

       

      I am trying to see YTD sales for 3 different years

       

      when I am using the formula

       

      IF [date]<=TODAY() AND DATEDIFF('year',[date],Today())= 0 THEN [sales] END

       

      I am getting null value for the year FY2013

       

      Please note that my Fiscal year starts from April

       

      Hence I have FY 2013,FY 2014,FY2015

       

      please help me on this

       

      Thanks,

      Praveen