From mboxrd@z Thu Jan  1 00:00:00 1970
From: Bernt Hansen <bernt@alumni.uwaterloo.ca>
Subject: Table calculation question
Date: Sun, 26 Aug 2007 15:39:41 -0400
Message-ID: <871wdqhypu.fsf@gollum.intra.norang.ca>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43)
	id 1IPNxy-00044F-Ui
	for emacs-orgmode@gnu.org; Sun, 26 Aug 2007 15:40:11 -0400
Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43)
	id 1IPNxu-00043p-J0
	for emacs-orgmode@gnu.org; Sun, 26 Aug 2007 15:40:10 -0400
Received: from [199.232.76.173] (helo=monty-python.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1IPNxu-00043m-DF
	for emacs-orgmode@gnu.org; Sun, 26 Aug 2007 15:40:06 -0400
Received: from main.gmane.org ([80.91.229.2] helo=ciao.gmane.org)
	by monty-python.gnu.org with esmtps (TLS-1.0:RSA_AES_256_CBC_SHA1:32)
	(Exim 4.60) (envelope-from <geo-emacs-orgmode@m.gmane.org>)
	id 1IPNxt-0000JW-W2
	for emacs-orgmode@gnu.org; Sun, 26 Aug 2007 15:40:06 -0400
Received: from list by ciao.gmane.org with local (Exim 4.43)
	id 1IPNxl-0007fd-Ii
	for emacs-orgmode@gnu.org; Sun, 26 Aug 2007 21:39:57 +0200
Received: from cpe000102d0fe75-cm0012256ecbde.cpe.net.cable.rogers.com
	([74.119.210.211]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <emacs-orgmode@gnu.org>; Sun, 26 Aug 2007 21:39:57 +0200
Received: from bernt by
	cpe000102d0fe75-cm0012256ecbde.cpe.net.cable.rogers.com with
	local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00
	for <emacs-orgmode@gnu.org>; Sun, 26 Aug 2007 21:39:57 +0200
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/pipermail/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: emacs-orgmode@gnu.org

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(@-II..@-I)::$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