From mboxrd@z Thu Jan 1 00:00:00 1970 From: "William Henney" Subject: Re: table formula question Date: Tue, 5 Jun 2007 20:39:33 -0500 Message-ID: <41c818190706051839g4a0a4eax1545bc8e6d3fa7df@mail.gmail.com> References: 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 1HvkUq-00035p-U5 for emacs-orgmode@gnu.org; Tue, 05 Jun 2007 21:39:36 -0400 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1HvkUp-00035d-Cz for emacs-orgmode@gnu.org; Tue, 05 Jun 2007 21:39:36 -0400 Received: from [199.232.76.173] (helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1HvkUp-00035a-7u for emacs-orgmode@gnu.org; Tue, 05 Jun 2007 21:39:35 -0400 Received: from an-out-0708.google.com ([209.85.132.247]) by monty-python.gnu.org with esmtp (Exim 4.60) (envelope-from ) id 1HvkUo-0003FS-PR for emacs-orgmode@gnu.org; Tue, 05 Jun 2007 21:39:35 -0400 Received: by an-out-0708.google.com with SMTP id c25so402666ana for ; Tue, 05 Jun 2007 18:39:34 -0700 (PDT) In-Reply-To: Content-Disposition: inline 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: emacs-orgmode Cc: Eddward DeVilla Hi Eddward Does this do what you want? * wealth management |--------------------------+---------+---------| | item | amount | balance | |--------------------------+---------+---------| | paid | 50.00 | 50.00 | | baby's new part of shoes | -25.00 | 25.00 | | chip | -2.50 | 22.50 | | my birthday! | 100.00 | 122.50 | | speeding fine :( | -200.00 | -77.50 | |--------------------------+---------+---------| #+TBLFM: $3=3Dvsum(@-I$-1..$-1);f2 By explicitly doing the summation, I avoid any dependence on the order in which each row is calculated. I think that your version fails because your formula makes no sense for the first row: you can't add a string ("total") to a float (50.00). Cheers Will On 6/5/07, Eddward DeVilla wrote: > Hi, > > I'm having trouble trying to figure out what I've got wrong here. > Given the table > > * wealth management > |--------------------------+--------+-------| > | item | amount | total | > |--------------------------+--------+-------| > | paid | 50.00 | | > | baby's new part of shoes | -25.00 | | > | chip | -2.50 | | > |--------------------------+--------+-------| > #+TBLFM: $3=3D'(+ @-1 $-1) > > > I would expect to get the results > > * wealth management > |--------------------------+--------+-------| > | item | amount | total | > |--------------------------+--------+-------| > | paid | 50.00 | 50.00 | > | baby's new part of shoes | -25.00 | 25.00 | > | chip | -2.50 | 22.50 | > |--------------------------+--------+-------| > #+TBLFM: $3=3D'(+ @-1 $-1) > > > But instead I just get > > * wealth management > |--------------------------+--------+--------| > | item | amount | total | > |--------------------------+--------+--------| > | paid | 50.00 | #ERROR | > | baby's new part of shoes | -25.00 | #ERROR | > | chip | -2.50 | #ERROR | > |--------------------------+--------+--------| > #+TBLFM: $3=3D'(+ @-1 $-1) > > > I'm sure I'm missing something. Is a table like this even possible? > > Edd > > > _______________________________________________ > Emacs-orgmode mailing list > Emacs-orgmode@gnu.org > http://lists.gnu.org/mailman/listinfo/emacs-orgmode > --=20 Dr William Henney, Centro de Radioastronom=EDa y Astrof=EDsica, Universidad Nacional Aut=F3noma de M=E9xico, Campus Morelia