From mboxrd@z Thu Jan  1 00:00:00 1970
From: James Hawley <yelwah1@comcast.net>
Subject: Re: Rounding in org-mode tables
Date: Thu, 30 Aug 2007 21:49:44 -0400
Message-ID: <1d8d6569e393aacf8380f89236a9db27@comcast.net>
References: <eaa81743b2275ba51296e2eb957f6b3a@comcast.net>
	<ad094edefba60c2a29ef698c52feb378@science.uva.nl>
Mime-Version: 1.0 (Apple Message framework v624)
Content-Type: text/plain; charset=US-ASCII; format=flowed
Content-Transfer-Encoding: 7bit
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 1IQvdu-00025M-O9
	for emacs-orgmode@gnu.org; Thu, 30 Aug 2007 21:49:50 -0400
Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43)
	id 1IQvdr-00021Y-5H
	for emacs-orgmode@gnu.org; Thu, 30 Aug 2007 21:49:49 -0400
Received: from [199.232.76.173] (helo=monty-python.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1IQvdq-00021V-WC
	for emacs-orgmode@gnu.org; Thu, 30 Aug 2007 21:49:47 -0400
Received: from sccrmhc14.comcast.net ([204.127.200.84])
	by monty-python.gnu.org with esmtp (Exim 4.60)
	(envelope-from <yelwah1@comcast.net>) id 1IQvdq-0006at-MU
	for emacs-orgmode@gnu.org; Thu, 30 Aug 2007 21:49:46 -0400
In-Reply-To: <ad094edefba60c2a29ef698c52feb378@science.uva.nl>
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: Carsten Dominik <dominik@science.uva.nl>
Cc: emacs-orgmode@gnu.org

Carsten,

Many Thanks for your rapid response - your suggestion worked and your 
caution was helpful as well (e.g., using f7 showed 3 additional zeros).

For anyone reading the list that might be interested, here's how I 
fixed the example to get the two digits to the right of the decimal to 
print correctly.

Original table and formula

935.15
6483.80
7419.00
#+TBLFM: @16$4=vsum(@3$4..@4$4);%.2f    Original formula yields 7419.00


Fixed table and formula

935.15
6483.80
7419.00
#+TBLFM: @16$4=vsum(@3$4..@4$4);f6%.2f   Revised formula yields 7418.95
                                                                         
  ^^
                                                                        
added formatting



Jim