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
