3 Replies Latest reply on Apr 12, 2013 9:30 AM by Robin Kennedy

    Handling Null Data -

    Gregg Ferguson

      In the attached workbook I am trying to extend the last available value for "Running Loss" (650) to periods 7 through 12. 

       

      It seems like this should be possible since

      1) "Running Loss No Nulls" is capable of putting 0 in periods 7 through 12

      and

      2) "Running Loss - Adjusted" is capable of putting 999 in the same periods

       

      However when I try "Running Loss - Adjusted 1" using the lookup function - I get the value I am looking for in period 7 but not in periods 8 through12.

       

      Am I missing something or is this just not possible.