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!
Get Started with Idea Exchange
See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!