Re: [O] Mean of a column in a remote table

2018-12-13 Thread Roger Mason
Hello Eric, Eric S Fraga writes: > Umm, I think you want to do the mean of the remote entries so try: > vmean(remote($1,@2..@>)) but I also wonder whether you need to specify > the column as well for remote references? At least, when I have done > this, I have specified both rows and columns,

Re: [O] Mean of a column in a remote table

2018-12-13 Thread Eric S Fraga
On Thursday, 13 Dec 2018 at 10:38, Roger Mason wrote: > Hello Eric, > > Eric S Fraga writes: > >> That should have been @>, not @<. > > | Data | a | > |---+| > | mic_2_in_648_cell | #ERROR | > > #+tblfm: $2=remote($1,vmean(@2..@>)) > > and 'Cells in the

Re: [O] Mean of a column in a remote table

2018-12-13 Thread Roger Mason
Hello Eric, Eric S Fraga writes: > That should have been @>, not @<. | Data | a | |---+| | mic_2_in_648_cell | #ERROR | #+tblfm: $2=remote($1,vmean(@2..@>)) and 'Cells in the region copied, use M-x org-table-paste-rectangle to paste them in a table.'

Re: [O] Mean of a column in a remote table

2018-12-13 Thread Eric S Fraga
That should have been @>, not @<. -- Eric S Fraga via Emacs 27.0.50, Org release_9.1.14-1034-gafcb1d

Re: [O] Mean of a column in a remote table

2018-12-13 Thread Eric S Fraga
On Thursday, 13 Dec 2018 at 09:12, Roger Mason wrote: > #+tblfm: $2=remote($1,vmean(@2..@-1)) [...] > The second column of the upper table is intended to receive the mean of > table 'mic_2_in_648_cell'. Instead I get the error 'Row descriptor -1 > leads outside table'. Try @< instead of @-1?

[O] Mean of a column in a remote table

2018-12-13 Thread Roger Mason
Hello, I _think_ this question has a simple answer, but I cannot find it. I need the mean of a column in a remote table. My current attempt looks like this: | Data | a | |---+---| | mic_2_in_648_cell | | #+tblfm: $2=remote($1,vmean(@2..@-1)) #+name: