[Top][All Lists]

[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 <address@hidden> wrote:
>* address@hidden wrote:*
>* > On Jun 7, 7:18 am, Cecil Westerhof <address@hidden> 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(@address@hidden);%.2f | | 11335.00 |*
>* >> |--------+------------------------+-------+----------|*
>* >> #+TBLFM: $4=$2*$3;%.2f::@6$4=vsum(@address@hidden);%.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