Hi,
I'm currently building a report that is attempting to compare data from the next following row, similarly to previous but in the opposite direction.
For example,
Order Number
100
200
200
I've used previous to determine that the middle 200 is not equal to the previous 100. How would I determine if the middle 200 is equal to the bottom 200?
Thanks and kind regards,
Brendan