Hi Karl On Sat, Oct 5, 2013 at 6:08 PM, Karl Voit <devn...@karl-voit.at> wrote: > | Descr | Current Data2+ | diff | abs.diff | > |-------+----------------+------+----------| > | foo | 9 | -1 | 1 | > | bar | 20 | -4 | 4 | > | baz | 23 | +6 | 6 | > |-------+----------------+------+----------| > | sum | 52 | | 11 | > > $2 are manually entered values to compare Data2 from above. I still > have no idea how to adopt your reference example for $3 and $4. > Would you please help me one more time?
Here you are: #+NAME: Data23vert | Descr+ | Data1+ | Data2+ | |--------+--------+--------| | foo | 12 | 10 | | bar | 22 | 24 | | baz | 16 | 17 | |--------+--------+--------| | sum | 50 | 51 | | Descr | Current Data2+ | diff | abs.diff | |-------+----------------+------+----------| | foo | 9 | -1 | 1 | | bar | 20 | -4 | 4 | | baz | 23 | 6 | 6 | |-------+----------------+------+----------| | sum | 52 | | 11 | #+TBLFM: $3 = $2 - remote(Data23vert, @@#$3) :: $4 = abs($3) :: @5$3 = string("") :: @5$4 = vsum(@I..@II) Or use $4 = abs($2 - remote(Data23vert, @@#$3)) if you prefer. Michael