Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be use Peek(WIP, -2)
Peek('WIP', -1)
Sorry Missed the Quotes. Just keep quotes around the Fieldname.
Still showing up different values.
You said latest WIP right?
May be try below?
(Peek(WIP) - ((Peek(WIP,-2)) - Processed)) as WIP_Test
Hello Joshua,
If you are using this in your inline script, then below might help.
(Peek('WIP') - ((Previous(WIP,-1)) - Processed)) as WIP_Test
Here is my file. I can't figure out why its not working correctly.
Can you share your excel file just for reloading purpose. ?
Here is excel file.