Re: [O] Difference between two rows

[Michael Brand]

Hi Cecil

On Sun, Jun 1, 2014 at 1:38 PM, Cecil Westerhof <address@hidden> 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(@address@hidden) == 1, string(""), $1 - @-1$1); E

Michael