From mboxrd@z Thu Jan 1 00:00:00 1970 From: Marko =?ISO-8859-1?Q?Sch=FCtz?= Subject: field formula referencing field from other table? Date: Thu, 08 Oct 2009 12:43:08 -0400 Message-ID: <8763apet0j.wl%MarkoSchuetz@web.de> Mime-Version: 1.0 (generated by SEMI 1.14.6 - "Maruoka") Content-Type: multipart/mixed; boundary="===============0586813398==" Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1Mvw5K-0008WM-3w for emacs-orgmode@gnu.org; Thu, 08 Oct 2009 12:43:22 -0400 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1Mvw5E-0008ST-B8 for emacs-orgmode@gnu.org; Thu, 08 Oct 2009 12:43:21 -0400 Received: from [199.232.76.173] (port=50064 helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1Mvw5E-0008SK-7H for emacs-orgmode@gnu.org; Thu, 08 Oct 2009 12:43:16 -0400 Received: from fmmailgate03.web.de ([217.72.192.234]:45871) by monty-python.gnu.org with esmtp (Exim 4.60) (envelope-from ) id 1Mvw5D-0001oj-KA for emacs-orgmode@gnu.org; Thu, 08 Oct 2009 12:43:16 -0400 Received: from smtp05.web.de (fmsmtp05.dlan.cinetic.de [172.20.4.166]) by fmmailgate03.web.de (Postfix) with ESMTP id DECD811FDE20C for ; Thu, 8 Oct 2009 18:43:12 +0200 (CEST) Received: from [74.213.77.105] (helo=prpad.dyndns.org) by smtp05.web.de with asmtp (TLSv1:AES128-SHA:128) (WEB.DE 4.110 #314) id 1Mvw5A-0006Tk-00 for emacs-orgmode@gnu.org; Thu, 08 Oct 2009 18:43:12 +0200 List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: Org Mode Mailing List --===============0586813398== Content-Type: multipart/signed; boundary="pgp-sign-Multipart_Thu_Oct__8_12:43:08_2009-1"; micalg=pgp-sha1; protocol="application/pgp-signature" Content-Transfer-Encoding: 7bit --pgp-sign-Multipart_Thu_Oct__8_12:43:08_2009-1 Content-Type: text/plain; charset=US-ASCII Dear All, I have two tables in a file, each being summed separately. Now I'd like to have a third table summing the two sub-sums. Here is an example: \begin{comment} #+ORGTBL: SEND criterion1 orgtbl-to-latex :splice t :skip 2 | Positions | \euro | |-----------+---------| | pos 1.1 | 465.87 | | pos 1.2 | 512.28 | | pos 1.3 | 2689.78 | | pos 1.4 | 1920.55 | |-----------+---------| | Sum 1 | 5588.48 | #+TBLFM: @6$2=vsum(@2..@5);%.2f \end{comment} \begin{comment} #+ORGTBL: SEND criterion2 orgtbl-to-latex :splice t :skip 2 | Positions | \euro | |-----------+---------| | pos 2.1 | 1083.37 | | pos 2.1 | 334.87 | |-----------+---------| | Sum 2 | 1418.24 | #+TBLFM: @4$2=vsum(@2..@3);%.2f \end{comment} and the table summing the sub-sums: \begin{comment} #+ORGTBL: SEND total orgtbl-to-latex :splice t :skip 2 | Positions | \euro | |-----------------+-------| | Sum criterion 1 | | | Sum criterion 2 | | |-----------------+-------| | Total | | #+TBLFM: @2$2=????;%.2f::@3$2=????;%.2f::@4$2=vsum(@2..@3);%.2f \end{comment} Any advice would be greatly appreciated. Best regards, Marko --pgp-sign-Multipart_Thu_Oct__8_12:43:08_2009-1 Content-Type: application/pgp-signature Content-Transfer-Encoding: 7bit -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.9 (NetBSD) iEYEABECAAYFAkrOFpwACgkQOrTq/v3ACNo+CwCgjbYavQot+49k83Oou3V9dwBL K6AAn0oli0WvLOWXIN0COY/d8DtYbgjx =u2Ra -----END PGP SIGNATURE----- --pgp-sign-Multipart_Thu_Oct__8_12:43:08_2009-1-- --===============0586813398== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ Emacs-orgmode mailing list Remember: use `Reply All' to send replies to the list. Emacs-orgmode@gnu.org http://lists.gnu.org/mailman/listinfo/emacs-orgmode --===============0586813398==--