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,
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
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.'
That should have been @>, not @<.
--
Eric S Fraga via Emacs 27.0.50, Org release_9.1.14-1034-gafcb1d
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?
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: