[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [O] Mean of a column in a remote table
From: |
Eric S Fraga |
Subject: |
Re: [O] Mean of a column in a remote table |
Date: |
Thu, 13 Dec 2018 16:14:43 +0000 |
User-agent: |
Gnus/5.13 (Gnus v5.13) Emacs/27.0.50 (gnu/linux) |
On Thursday, 13 Dec 2018 at 10:38, Roger Mason wrote:
> Hello Eric,
>
> Eric S Fraga <address@hidden> 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.' in the Message buffer.
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,
e.g. vmean(remote(xxx,@<$>..@>$>)).
--
Eric S Fraga via Emacs 27.0.50, Org release_9.1.14-1034-gafcb1d