1 Reply Latest reply on Aug 12, 2016 8:37 AM by Amber Loranger

    First, Land and Middle Forecast Values

    steve walker

      Hi all, first post!

       

      I have Delivery data which has a number of forecast dates. These forecasts do not occur over the weekend. I would like to return the initial, middle (D+7 always has a value, so I'll use this), and final forecast value for each Delivery date.

       

      Thanks for any suggestions.

        • 1. Re: First, Land and Middle Forecast Values
          Amber Loranger

          Hi Steve,

          Have you found a solution to this issue?

          I took a look at the Excel file and screenshot you shared, but I'm not familiar enough with this type of data to be sure what end result you're looking for. If you could share a workbook (twbx) and say a little more about how what you've achieved is different from what you want, that could help us sort it out.