Re: [Orgmode] table formula question

[Eddward DeVilla]

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 <address@hidden> 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 <address@hidden> 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
> > address@hidden
> > 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