From mboxrd@z Thu Jan 1 00:00:00 1970 From: Eric S Fraga Subject: Re: Mean of a column in a remote table Date: Thu, 13 Dec 2018 16:14:43 +0000 Message-ID: <87tvjh4d58.fsf@gmail.com> References: <875zvxblvl.fsf@gmail.com> Mime-Version: 1.0 Content-Type: text/plain Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:38524) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1gXTdS-0002C0-JD for emacs-orgmode@gnu.org; Thu, 13 Dec 2018 11:14:56 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1gXTdN-0001d5-RW for emacs-orgmode@gnu.org; Thu, 13 Dec 2018 11:14:50 -0500 Received: from mail-wm1-x333.google.com ([2a00:1450:4864:20::333]:52989) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_128_CBC_SHA1:16) (Exim 4.71) (envelope-from ) id 1gXTdN-0001cm-GG for emacs-orgmode@gnu.org; Thu, 13 Dec 2018 11:14:45 -0500 Received: by mail-wm1-x333.google.com with SMTP id m1so2941116wml.2 for ; Thu, 13 Dec 2018 08:14:45 -0800 (PST) In-Reply-To: (Roger Mason's message of "Thu, 13 Dec 2018 10:38:43 -0330") List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Sender: "Emacs-orgmode" To: Roger Mason Cc: Org-Mode 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 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