PREVIOUSITEM() formula which is like PREVIOUS() but references a list item instead of time
I was searching for the use of the PREVIOUS function but on a list item but it is not currently possible.
@peter_mcanena has suggested this but only in a discussion thread.
So as his idea suggests:
PREVIOUSITEM(x, y) where
- x: Any expression
- y: List
The expression x must be based on the list y. PREVIOUSITEM(x, y) would then pick up the value of x from the previous item in the list y.
Anaplan would need to allow PREVIOUSITEM(x, y) to be used in the definition of x itself, in the same way as PREVIOUS(), without creating a circular reference.
full thread here:
It would be great if this was developed!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.