all messages for Emacs-related lists mirrored at yhetil.org
 help / color / mirror / code / Atom feed
* Mean of a column in a remote table
@ 2018-12-13 12:42 Roger Mason
  2018-12-13 13:23 ` Eric S Fraga
  2018-12-13 13:24 ` Eric S Fraga
  0 siblings, 2 replies; 6+ messages in thread
From: Roger Mason @ 2018-12-13 12:42 UTC (permalink / raw)
  To: Org-Mode

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/)

^ permalink raw reply	[flat|nested] 6+ messages in thread

end of thread, other threads:[~2018-12-13 18:24 UTC | newest]

Thread overview: 6+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2018-12-13 12:42 Mean of a column in a remote table Roger Mason
2018-12-13 13:23 ` Eric S Fraga
2018-12-13 13:24 ` Eric S Fraga
2018-12-13 14:08   ` Roger Mason
2018-12-13 16:14     ` Eric S Fraga
2018-12-13 18:24       ` Roger Mason

Code repositories for project(s) associated with this external index

	https://git.savannah.gnu.org/cgit/emacs.git
	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is an external index of several public inboxes,
see mirroring instructions on how to clone and mirror
all data and code used by this external index.