6 Replies Latest reply on Jul 27, 2017 8:55 AM by mariam.ah

    Previous Period for last year

    mariam.ah

      Hi all,

      i could calculate the value of sales  from  2 parametre date  : start date and end date

      Date range:

      [Date order]>=[start date ] and [Date order ]<=[end date]

      current periode

      IF [Date range ]= TRUE then [sales] END

      and it works but my need is to calculate the same period for last year

      for example : start date :01/02/207 and  end date : 05/10/2017  sales for current periode is 10000

      i need to calculate the value of sales in the last year betwenn 01/02/2016 and 05/10/2016

      Thank you in advance