I need to be able to take a numeric object that increases or decreases in an iterative function and use it in a column formula. In the equation below, the values of col, l and m need to be evaluated in the column formula. How can I get this to happen? Parse(), Eval() and Num() aren't working.
For( i = 1, i <=8, i++,
col = 11+i;
l = col - i;
m = col + 1 - i;
colno = Char(col);
New Column("Column "||colno, Character, "Nominal", Formula(If(Row() == 12, Lag(Column(1), l), If(Row() == 13, Lag(Column(2), m), Lag(Column(col, 1)))))));
Slán
SpannerHead