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