Thanks, Michael, for this helpful workaround!


On Fri, Mar 21, 2014 at 8:19 AM, Michael Brand
<michael.ch.brand@gmail.com>wrote:

> Hi Volker
>
> On Fri, Mar 21, 2014 at 1:31 AM, Volker Strobel
> <volker.strobel87@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
>