Thanks, Michael, for this helpful workaround!
On Fri, Mar 21, 2014 at 8:19 AM, Michael Brand <michael.ch.br...@gmail.com>wrote: > Hi Volker > > On Fri, Mar 21, 2014 at 1:31 AM, Volker Strobel > <volker.strobe...@gmail.com> wrote: > > My problem is, that this remote reference starts in row 3 (because of > @$#), > > however, I'd like to start in row 2 (that means @$#-1). However, this > > relative reference does not seem to work here. > > Calculation within the field reference of Org is not supported but > subscr of Calc can be used to pick calculated references from a range: > > #+NAME: my-table > | Header1 | Header2 | > |---------+---------| > | a | 23 | > | b | 7 | > | c | 13 | > | d | 66 | > | e | 5 | > |---------+---------| > | Result | 42 | > > | x | y | 23 | 7 | 13 | 66 | 5 | > #+TBLFM: @1$3..@1$7 = subscr(remote(my-table, @2$2..6$2), $# - 2) > > (To show the intermediade step: > | x | y | [23, 7, 13, 66, 5] | [23, 7, 13, 66, 5] | > #+TBLFM: @1$3..@1$4 = remote(my-table, @2$2..6$2) > ) > > Michael >
