Hi! I want to use the column "average" of the first table to fill the column "h1" in the second one.
#+TBLNAME: 2012-08-12vkmeasure | tags/item | m1 | m2 | m3 | average | |-----------+-------+-------+-------+---------| | 4 | 0.02 | 0.03 | 0.02 | 0.02 | | 5 | 0.06 | 0.12 | 0.06 | 0.08 | | 6 | 0.31 | 0.53 | 0.29 | 0.38 | | 7 | 3.83 | 4.08 | 4.48 | 4.13 | | 8 | 85.33 | 89.22 | 92.07 | 88.87 | #+TBLFM: $5 = vmean($2..$4);%.2f | tags/item | h1 [s] | h2 [s] | |-----------+--------+--------| | 4 | | | | 5 | | | | 6 | | | | 7 | | | | 8 | | | #+TBLFM: <fillme> I tried following references but failed so far: @2$2..@6$2=subscr(remote(2012-08-12vkmeasure,@2$5..@6$5),$#) #-> 0.08 0.08 ... @2$2=remote(2012-08-12vkmeasure,@2$5) -> works for one value @2$2..@6$2=subscr(remote(2012-08-12vkmeasure,@2$5..@6$5),$#) #-> 0.08 0.08 ... $2=subscr(remote(2012-08-12vkmeasure,@I$>..@II$>),$#) What did I do wrong? How is the correct TBLFM in order to get 0.02 ... 88.87 into the h1-column? Thanks for your help! -- Karl Voit