From mboxrd@z Thu Jan 1 00:00:00 1970 From: Stephan Schmitt Subject: Re: field formula referencing field from other table? Date: Thu, 08 Oct 2009 22:17:28 +0200 Message-ID: <4ACE48D8.1060602@cs.tu-berlin.de> References: <8763apet0j.wl%MarkoSchuetz@web.de> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1MvzWV-00005s-51 for emacs-orgmode@gnu.org; Thu, 08 Oct 2009 16:23:39 -0400 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1MvzWQ-00004z-2q for emacs-orgmode@gnu.org; Thu, 08 Oct 2009 16:23:38 -0400 Received: from [199.232.76.173] (port=36643 helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1MvzWP-00004w-Tl for emacs-orgmode@gnu.org; Thu, 08 Oct 2009 16:23:33 -0400 Received: from mail.cs.tu-berlin.de ([130.149.17.13]:62316) by monty-python.gnu.org with esmtps (TLS-1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.60) (envelope-from ) id 1MvzWP-0007q4-GM for emacs-orgmode@gnu.org; Thu, 08 Oct 2009 16:23:33 -0400 Received: from localhost (localhost [127.0.0.1]) by localhost-12225.cs.tu-berlin.de (Postfix) with ESMTP id 66BD1300F6 for ; Thu, 8 Oct 2009 22:23:05 +0200 (MEST) In-Reply-To: <8763apet0j.wl%MarkoSchuetz@web.de> 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: =?ISO-8859-1?Q?Marko_Sch=FCtz?= Cc: Org Mode Mailing List Hi Marco, take a look at section 3.5.1 of the org-mode info in *scratch*: (info "(org)References") C-x C-e in particular at the last section of this page. HTH, Stephan Marko Sch=FCtz wrote: > Dear All, >=20 > 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. >=20 > Here is an example: >=20 > \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=3Dvsum(@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=3Dvsum(@2..@3);%.2f > \end{comment} >=20 > and the table summing the sub-sums: >=20 > \begin{comment} > #+ORGTBL: SEND total orgtbl-to-latex :splice t :skip 2 > | Positions | \euro | > |-----------------+-------| > | Sum criterion 1 | | > | Sum criterion 2 | | > |-----------------+-------| > | Total | | > #+TBLFM: @2$2=3D????;%.2f::@3$2=3D????;%.2f::@4$2=3Dvsum(@2..@3);%.2f > \end{comment} >=20 > Any advice would be greatly appreciated. >=20 > Best regards, >=20 > Marko >=20 >=20 > -----------------------------------------------------------------------= - >=20 > _______________________________________________ > 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