From mboxrd@z Thu Jan  1 00:00:00 1970
From: Michael Brand <michael.ch.brand@gmail.com>
Subject: Re: how to avoid floating number problems with org-table for
 finances?
Date: Thu, 1 Nov 2012 19:04:39 +0100
Message-ID: <CALn3zojnJf4A0oqYKwXrf3gVUBDQUw-HOdPB=iFDhayik5yB0w@mail.gmail.com>
References: <201210121907.00833.thomas@koch.ro>
Mime-Version: 1.0
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([208.118.235.92]:47707)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1TTz8G-0007LX-Ap
	for emacs-orgmode@gnu.org; Thu, 01 Nov 2012 14:04:45 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1TTz8E-00072q-9o
	for emacs-orgmode@gnu.org; Thu, 01 Nov 2012 14:04:43 -0400
Received: from mail-la0-f41.google.com ([209.85.215.41]:39554)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1TTz8E-00072d-2G
	for emacs-orgmode@gnu.org; Thu, 01 Nov 2012 14:04:42 -0400
Received: by mail-la0-f41.google.com with SMTP id p5so2350642lag.0
	for <emacs-orgmode@gnu.org>; Thu, 01 Nov 2012 11:04:40 -0700 (PDT)
In-Reply-To: <201210121907.00833.thomas@koch.ro>
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: thomas@koch.ro
Cc: emacs-orgmode@gnu.org

Hi Thomas

I hope it=92s not too late but I got into some backlog with reading the lis=
t.

On Fri, Oct 12, 2012 at 7:06 PM, Thomas Koch <thomas@koch.ro> wrote:
> #+TBLFM: @4$1=3Dvsum(@1..@3);%.40f

For your example I would recommend:
#+TBLFM: @4$1=3Dvsum(@1..@3); f-2
or if you really want 40 digits precision for the calculations behind:
#+TBLFM: @4$1=3Dvsum(@1..@3); p40 f-2
Please read my explanations here:
http://orgmode.org/worg/org-faq.html#table-high-precision

The integer calculation you suggested with decimal point notation is
not possible out of the box and if at all I would rather go the way of
Calc Fractions to get infinite precision:
| 3:10 |
| 3:10 |
| 3:10 |
| 9:10 |
#+TBLFM: @4$1=3Dvsum(@1..@3); F

Michael