From mboxrd@z Thu Jan  1 00:00:00 1970
From: "Eddward DeVilla" <eddward@gmail.com>
Subject: table formula question
Date: Tue, 5 Jun 2007 16:40:04 -0500
Message-ID: <b71b18520706051440v2328c424x497ac5d9127565c8@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43)
	id 1Hvgl6-0001Vt-JK
	for emacs-orgmode@gnu.org; Tue, 05 Jun 2007 17:40:08 -0400
Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43)
	id 1Hvgl6-0001Ur-4y
	for emacs-orgmode@gnu.org; Tue, 05 Jun 2007 17:40:08 -0400
Received: from [199.232.76.173] (helo=monty-python.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1Hvgl5-0001Ug-4d
	for emacs-orgmode@gnu.org; Tue, 05 Jun 2007 17:40:07 -0400
Received: from wa-out-1112.google.com ([209.85.146.183])
	by monty-python.gnu.org with esmtp (Exim 4.60)
	(envelope-from <eddward@gmail.com>) id 1Hvgl4-0002nW-NZ
	for emacs-orgmode@gnu.org; Tue, 05 Jun 2007 17:40:06 -0400
Received: by wa-out-1112.google.com with SMTP id k34so2368293wah
	for <emacs-orgmode@gnu.org>; Tue, 05 Jun 2007 14:40:05 -0700 (PDT)
Content-Disposition: inline
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/pipermail/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=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 <emacs-orgmode@gnu.org>

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='(+ @-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='(+ @-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='(+ @-1 $-1)


I'm sure I'm missing something.  Is a table like this even possible?

Edd