5 Replies Latest reply on Feb 23, 2017 10:50 PM by Patrick A Van Der Hyde

    Is there a way to create something like (PREVIOUS_VALUE(0),-2)  ?

    Joe Oppelt

      I'm working with Joshua in this thread:

       

      Custom Moving Calculation?

       

      What I have determined is that he needs to be able to grab a previous value, but not just in the previous index like PREVIOUS_VALUE(0) does.  He needs to look back TWO previous values.

       

      And I've tangled myself up in my own thinking, and just need a fresh set of eyes.

       

      Is there a way to simulate PREVIOUS_VALUE looking back two heartbeats instead of just one?

       

      (Note:  The workbook in question there is 9.3)