5 Replies Latest reply on Jul 14, 2016 12:51 AM by Shinichiro Murakami

    Full Prior Year Independent of Date Filter

    Marlon Woolner

      I am trying to create a report that will show YTD Sales and Budget for the current year and in a separate column show the Full Prior Year sales. I have the following formula, but it returns nulls. Can anyone help?


      If [Inv Date] >= DATEPARSE('mm/dd/yyyy','01/01/2015') and [Inv Date]  <= DATEPARSE('mm/dd/yyyy','12/31/2015') then [Sales] ELSE 0 end


      This is what I trying to achieve