emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed

From: "Eddward DeVilla" <eddward@gmail.com>
To: William Henney <whenney@gmail.com>
Cc: emacs-orgmode <emacs-orgmode@gnu.org>
Subject: Re: table formula question
Date: Tue, 5 Jun 2007 20:48:52 -0500	[thread overview]
Message-ID: <b71b18520706051848w7a8eea3apb1e4a6a4f776dbf1@mail.gmail.com> (raw)
In-Reply-To: <41c818190706051839g4a0a4eax1545bc8e6d3fa7df@mail.gmail.com>

That looks like it will work.  I don't have calc on my work system so
I'll have to do the elisp equivalent but that won't be hard.  Say
something like so:

* wealth management
 |--------------------------+---------+---------|
 | item                     |  amount | balance |
 |--------------------------+---------+---------|
 | paid                     |   50.00 |   50.00 |
 | baby's new pair of shoes |  -25.00 |   25.00 |
 | chips                    |   -2.50 |   22.50 |
 | my birthday!             |  100.00 |  122.50 |
 | speeding fine :(         | -200.00 |  -77.50 |
 |--------------------------+---------+---------|
#+TBLFM: $3='(apply '+ '(@-I$-1..$-1));N%.2f

Thanks,
Edd

On 6/5/07, William Henney <whenney@gmail.com> wrote:
> 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
>

     prev parent reply	other threads:[~2007-06-06  1:48 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
2007-06-06  1:48   ` Eddward DeVilla [this message]

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=b71b18520706051848w7a8eea3apb1e4a6a4f776dbf1@mail.gmail.com \
    --to=eddward@gmail.com \
    --cc=emacs-orgmode@gnu.org \
    --cc=whenney@gmail.com \
    /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

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).