5 Replies Latest reply on Feb 23, 2017 10:50 PM by Patrick 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)