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

    Forward Values along periods with null value

      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:

       

      Current.JPG

       

      Here is how I would like it to be:

       

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

       

       

      Attached the QVW file.

       

      Thanks for your help!