Anyone have suggestions about how i can have a column-formula refer to
value in previous row, but ignore the row before the first line?
Something like this:
| 1 | 4 | |
| 2 | 7 | |
| 3 | 1 | |
#+TBLFM: $2=random(10)::$3=(@-1$2)-$2
Evaluating this returns an error:
"Row descriptor -1 used in line 547 leads outside table"
I tried using a lisp-expression to dispatch on the row-number, but it
doesnt seem to consider 'if as a special-form, trying to evaluate its
last argument anyhow.
| 1 | 2 | |
| 2 | 6 | |
| 3 | 2 | |
#+TBLFM: $2=random(10)::$3='(if (< @# 3) 0 (- @-1$2 $2))
but get the same error.
Thanks,
-anders