7 Replies Latest reply: May 15, 2013 5:49 AM by Ori Tal RSS

    Forward Values along periods with null value

    Ori Tal

      Hi All

      I have a forecast for Inventory values

      But, the values appear in the source table only

      if there was any expected transaction.

      I would like to to the following:

      In case a month has no value, forward the values from last period where there was a value (Total Forecast is 1 year)


      For example, here is my current table:




      Here is how I would like it to be:


      Wanted.JPG ..... Continue till 2014-05



      Attached the QVW file.


      Thanks for your help!