6 Replies Latest reply: Oct 1, 2013 7:50 AM by Janne Vauhkonen RSS

    Previous or Peek function???

      Hi

       

      I have a problem with my data. I know this should be fairly easy to solve with previous or peek functions, but I am not very familiar with them and can't make this work.

       

      I have following problem in my data

       

      periodquantityvaluation
      1111

      1,1

      22221,2
      3333-
      4444-
      5555-
      66661,3
      7777-
      88881,5

       

      I have a inventory data in where I have moving average valuation (in this example above "valuation"). However, I am missing this moving average value in every case in where I have no movements in the period. If there is no value, I would need to use the previous existing one. So in this case valuation in period 3 should be 1,2 and same thing in period 4 and 5. In period 7 I would need to use the value from period 6.

       

       

      Thanks already beforehand

       

      Regards

      Janne