emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed

From: Martin Gross <m-gross@gmx.net>
To: emacs-orgmode@gnu.org
Subject: sum up variables from different org-mode tables
Date: Fri, 16 Nov 2012 12:33:24 +0100	[thread overview]
Message-ID: <CAJkULmktbtUYOnZbhf_VLbhHoh8fiJca_6uOFK2qr7nDT0O+8Q@mail.gmail.com> (raw)

Dear helpers,

I have a big file where I enter incomings and outgoings of book
exchanges with different institutions:

* Institution A
  |   | In      |  # |   € | Out     |  # |   € |
  |---+---------+----+-----+---------+----+-----|
  |   | Title P |  1 |  45 | Title A |  1 |  15 |
  |   |         |    |     | Title B |  2 |  28 |
  |---+---------+----+-----+---------+----+-----|
  | # |         |  1 |  45 |         |  3 |  43 |
  | ^ |         | TE | TEE |         | TA | TAE |
  #+TBLFM: $TE=vsum(@I..@II)::$TEE=vsum(@I..@II)::$TA=vsum(@I..@II)::$TAE=vsum(@I..@II)

* Institution B
  |   | In | #  |  €   | Out | #   | €   |
  ...
  | # |    |  1 |  24  |     |  2  | 31  |
  | ^ |    | TE | TEE  |     | TA  | TAE |

Now I would like to get some statistics that consider all institutions
together.  For example summing up the "variable" TAE from all the
tables in the file to get the very total cost of outgoings.

Is something like that possible?

Thank you very much in advance!

Martin

next             reply	other threads:[~2012-11-16 11:33 UTC|newest]

Thread overview: 9+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2012-11-16 11:33 Martin Gross [this message]
2012-11-16 15:16 ` sum up variables from different org-mode tables Michael Brand
2012-11-19 11:54   ` Martin Gross
2012-11-19 13:50     ` Michael Brand
2012-11-21 17:01       ` Martin Gross
2012-11-21 18:46         ` Suvayu Ali
2012-11-19 21:21     ` Eric Schulte
2012-11-22 10:03       ` Martin Gross
2014-01-04 15:29   ` Michael Brand

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

  List information: https://www.orgmode.org/

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to=CAJkULmktbtUYOnZbhf_VLbhHoh8fiJca_6uOFK2qr7nDT0O+8Q@mail.gmail.com \
    --to=m-gross@gmx.net \
    --cc=emacs-orgmode@gnu.org \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link

Code repositories for project(s) associated with this public inbox

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

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).