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?



      also tried Previous()


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


      That doesn't work either.