From: "William Henney" <whenney@gmail.com>
To: emacs-orgmode <emacs-orgmode@gnu.org>
Cc: Eddward DeVilla <eddward@gmail.com>
Subject: Re: table formula question
Date: Tue, 5 Jun 2007 20:39:33 -0500 [thread overview]
Message-ID: <41c818190706051839g4a0a4eax1545bc8e6d3fa7df@mail.gmail.com> (raw)
In-Reply-To: <b71b18520706051440v2328c424x497ac5d9127565c8@mail.gmail.com>
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=vsum(@-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 <eddward@gmail.com> 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='(+ @-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
>
>
> _______________________________________________
> Emacs-orgmode mailing list
> Emacs-orgmode@gnu.org
> http://lists.gnu.org/mailman/listinfo/emacs-orgmode
>
--
Dr William Henney, Centro de Radioastronomía y Astrofísica,
Universidad Nacional Autónoma de México, Campus Morelia
next prev parent reply other threads:[~2007-06-06 1:39 UTC|newest]
Thread overview: 3+ messages / expand[flat|nested] mbox.gz Atom feed top
2007-06-05 21:40 table formula question Eddward DeVilla
2007-06-06 1:39 ` William Henney [this message]
2007-06-06 1:48 ` Eddward DeVilla
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=41c818190706051839g4a0a4eax1545bc8e6d3fa7df@mail.gmail.com \
--to=whenney@gmail.com \
--cc=eddward@gmail.com \
--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
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
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).