3 Replies Latest reply on Jan 27, 2014 11:20 AM by Steve Gesuale

    revising calc's to show one year ago

    Steve Gesuale

      Hi,

       

      I am using the below calc’s to display a selected day’s sales based on the date selected in a parameter (Chosen Date).

       

      IF[Date]<=[Chosen Date] and DATEDIFF('day',[Date],[Chosen Date])=0 THEN [Sales] END

       

      I am struggling to change it so I can also show one day’s sales from the same day the previous year, e.g. 17 Jan 2013 if 17 Jan 2014 is selected. Probably an easy one, but I'm not getting it..

       

      Any advice appreciated!

      Thanks.

      Steve