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(@[EMAIL PROTECTED])::$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 _______________________________________________ Emacs-orgmode mailing list Emacs-orgmode@gnu.org http://lists.gnu.org/mailman/listinfo/emacs-orgmode
