[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Orgmode] Table calculation question
From: |
Bernt Hansen |
Subject: |
[Orgmode] Table calculation question |
Date: |
Sun, 26 Aug 2007 15:39:41 -0400 |
User-agent: |
Gnus/5.11 (Gnus v5.11) Emacs/22.1 (gnu/linux) |
In the following table I'd like to vertically sum the column and the
compute a new value based on that sum.
|---+---+---+---+-------+---------|
| | A | B | C | Total | Details |
|---+---+---+---+-------+---------|
| # | 1 | 2 | 4 | 7 | Item 1 |
| # | 2 | 6 | 4 | 12 | Item 2 |
| # | 2 | 4 | 4 | 10 | Item 3 |
| # | 2 | 6 | 3 | 11 | Item 4 |
|---+---+---+---+-------+---------|
| # | | | | 40 | 400.00 |
| ^ | | | | tot | result |
| $ | | | | | kval=10 |
|---+---+---+---+-------+---------|
#+TBLFM: $5=$2+$3+$4::$tot=vsum(@address@hidden)::$result=$tot*$kval;%.2f
If I edit any of the values in columns A, B, C and do C-u C-c C-c then
the total (tot) value is recalculated but result is not. Doing C-u C-c
C-c a second time recalculates result based on the new tot value.
Is there a way to do this in a single table recalculation?
Thanks,
Bernt
- [Orgmode] Table calculation question,
Bernt Hansen <=