Re: Problem with sum function in table in org-mode

[carsten.dominik@gmail.com]

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