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.