From mboxrd@z Thu Jan  1 00:00:00 1970
From: Roger Mason <rmason@mun.ca>
Subject: Mean of a column in a remote table
Date: Thu, 13 Dec 2018 09:12:45 -0330
Message-ID: <y65k1kdsim2.fsf@mun.ca>
Mime-Version: 1.0
Content-Type: text/plain
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:48923)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <rmason@mun.ca>) id 1gXQKO-000572-Ai
	for emacs-orgmode@gnu.org; Thu, 13 Dec 2018 07:42:57 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <rmason@mun.ca>) id 1gXQKJ-0004Ds-8A
	for emacs-orgmode@gnu.org; Thu, 13 Dec 2018 07:42:56 -0500
Received: from esa03.ucs.mun.ca ([134.153.136.23]:58228)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <rmason@mun.ca>) id 1gXQKI-0003yH-W1
	for emacs-orgmode@gnu.org; Thu, 13 Dec 2018 07:42:51 -0500
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode/>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Sender: "Emacs-orgmode"
	<emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
To: Org-Mode <emacs-orgmode@gnu.org>

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: mic_2_in_648_cell
|         a |
|-----------|
| 28.886207 |
| 28.900981 |
| 28.886101 |
| 28.900659 |
| 28.900526 |
| 28.886694 |
| 28.886559 |
|  28.90024 |
| 28.900524 |
| 28.900583 |
| 28.886496 |

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'.

This is a cut down example that captures the essence.

Thanks for any help.

Roger
GNU Emacs 26.1 (build 1, i386-portbld-freebsd11.2, GTK+ Version 3.22.29)
Org mode version 9.1.13 (release_9.1.13-784-ged7d1d @ /home/rmason/.emacs.d/org-git/lisp/)