18 Replies Latest reply: Oct 25, 2017 11:17 AM by VIJAY VIRA RSS

    Using Peek

    Joshua Russin

      Question for using peek.

       

      My data is already sorted by date, latest date is at the bottom.

      I am trying to load an equation with peek().

       

      (latest wip - (next to last wip - latest processed))

       

      Here is what I have in my script and is coming up with different values.

       

      (WIP - ((Peek(WIP,-1)) - Processed)) as WIP_Test

       

      any tips or other methods?

       

      Edit*

      also tried Previous()

       

      (WIP - ((Previous(WIP)) - Processed)) as WIP_Test

       

      That doesn't work either.