[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Problem with sum function in table in org-mode
From: |
carsten . dominik |
Subject: |
Re: Problem with sum function in table in org-mode |
Date: |
Fri, 08 Jun 2007 01:13:12 -0700 |
User-agent: |
G2/1.0 |
On Jun 8, 9:45 am, Cecil Westerhof <d...@dummy.nl> wrote:
> carsten.domi...@gmail.com wrote:
> > On Jun 7, 7:18 am, Cecil Westerhof <d...@dummy.nl> wrote:
> >> I have the following table inorg-mode:
>
> >> |--------+------------------------+-------+----------|
> >> | client | hours | tarif | amount |
> >> |--------+------------------------+-------+----------|
> >> | A | 12.50 | 75 | 937.50 |
> >> | B | 16.00 | 85 | 1360.00 |
> >> | C | 73.50 | 100 | 7350.00 |
> >> | D | 13.50 | 125 | 1687.50 |
> >> |--------+------------------------+-------+----------|
> >> | Total | :=vsum(@II..@III);%.2f | | 11335.00 |
> >> |--------+------------------------+-------+----------|
> >> #+TBLFM: $4=$2*$3;%.2f::@6$4=vsum(@II..@III);%.2f
>
> >> The total in the amount column works without a problem, but in the hours
> >> column it does not work. What is going wrong here?
>
> > Go into the table field with the formula and press either TAB or C-c C-
> > c.
>
> That works. I tried 'C-c *' what did work on the other fields, but not on
> this one. Well, I have a workaround now. ;=}
It is not really a work-around though. `C-c *' does re-apply all
stored formulas.
The formula you has typed was not yet stored (moved to the TBLFM
line),
that only happens when you press TAB or `C-c C-c' or RET in the field
where
you typed the formula, or if you enter the formula with the `C-c =' or
`C-u C-c C-=' commands.
- Carsten