Hi Cecil On Sun, Jun 1, 2014 at 1:38 PM, Cecil Westerhof <cldwester...@gmail.com> wrote: > I like to calculate in a table the difference between the value in a field > in the current row and the previous field. How would I do that? > > Something like: > |-------+------------| > | value | difference | > |-------+------------| > | 12 | | > | 15 | 3 | > | 83 | 68 | > | 87 | 4 | > | 85 | -2 | > |-------+------------|
For such cases I prefer vlen(): #+TBLFM: $2 = if(vlen(@II..@0) == 1, string(""), $1 - @-1$1); E Michael