4 Replies Latest reply on Oct 19, 2016 12:00 PM by Sreekanth Kasaraneni

    Issue fetching previous week data from current week

    tanya.kanwar.0

      Hi,

       

      I have data parameter which has picks all the date from report date.I have sales data available for Wednesday only.

      I want to pull the sales for selected date by users and Sales  -1 ( but here -1 should point to last week Wednesday data).

      i.e if user select 12th Oct, sales -1 should reflect 5th oct sales.

      My code is for Sales-1 is:

      IF [Report date Parameter]= (IF DATENAME('weekday',[Report date Parameter] )= 'Wednesday'

      then [Report date Parameter] -7

      END)

      then

      Zn([ Sales])

      END

       

      How can i do this ?Can anyone help..