0 Replies Latest reply: Jan 9, 2018 5:09 PM by Jacob Wapinsky RSS

    Relative data selection for variable date.

    Jacob Wapinsky

      Hi all,


      I am trying to establish a pacing table which compares equivalent time frames within months


      i.e. when i have 19 business days left in the month of January, where was I at historically


      I have the following data

      Order, Date, delivery date, Requested volume, business days remaining in month, product identifiers


      and a variable based on the max date selected in the file


      what i would like to do is


      when the days remaining for a date are >= the days remaining for a selected date then sum the requested volume over that date range