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