How to evaluate a column bottom to top?
I need to count negative indexes from a particular cell, how you make a single column evaluate bottom to top? Col 29 Col 310 -50 -40 -30 -20 -11 -421 -411 -40 If( Lag( :Column 29, -1 ) == 1 & :Column 29 == 0,
-1,
Lag( :Column 31, -1 ) - 1
)