From mboxrd@z Thu Jan  1 00:00:00 1970
From: "Eric Schulte" <schulte.eric@gmail.com>
Subject: Re: Formulas in columnview table
Date: Tue, 03 Feb 2009 07:13:28 -0800
Message-ID: <87iqnrft9j.fsf@gmail.com>
References: <loom.20090203T131700-913@post.gmane.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
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 1LUMxc-0006X2-24
	for emacs-orgmode@gnu.org; Tue, 03 Feb 2009 10:13:12 -0500
Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43)
	id 1LUMxX-0006VR-IN
	for emacs-orgmode@gnu.org; Tue, 03 Feb 2009 10:13:08 -0500
Received: from [199.232.76.173] (port=44271 helo=monty-python.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1LUMxX-0006VD-1t
	for emacs-orgmode@gnu.org; Tue, 03 Feb 2009 10:13:07 -0500
Received: from rv-out-0708.google.com ([209.85.198.245]:42957)
	by monty-python.gnu.org with esmtp (Exim 4.60)
	(envelope-from <schulte.eric@gmail.com>) id 1LUMxW-0004vH-Nl
	for emacs-orgmode@gnu.org; Tue, 03 Feb 2009 10:13:06 -0500
Received: by rv-out-0708.google.com with SMTP id k29so2386267rvb.6
	for <emacs-orgmode@gnu.org>; Tue, 03 Feb 2009 07:13:04 -0800 (PST)
In-Reply-To: <loom.20090203T131700-913@post.gmane.org> (=?utf-8?Q?=22Fl?=
	=?utf-8?Q?=C3=A1vio=22's?= message of
	"Tue, 3 Feb 2009 13:46:08 +0000 (UTC)")
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: =?utf-8?Q?Fl=C3=A1vio?= <flaviostz@gmail.com>
Cc: emacs-orgmode@gnu.org

Fl=C3=A1vio <flaviostz@gmail.com> writes:

> I am using columnview table now to get some summaries of worked hours and
> quantity balance as well. This is one example showing a quantity of quoted
> computers and the real sold quantity:
>
> |   | ITEM                    | Quotation | Sold |=20
> |---+-------------------------+-----------+------+
> |   | ** Computers            |      10   |  7   |
> |---+-------------------------+-----------+------+
>
> Is there any way to automatically insert a f=C3=B3rmula in a third column=
? For
> example, I could insert a "Difference" column and make Sold - Quotation a=
nd get
> this result:
>
> |   | ITEM                    | Quotation | Sold | Difference |
> |---+-------------------------+-----------+------+------------|
> |   | ** Computers            |      10   |  7   |     -3     |
> |---+-------------------------+-----------+------+------------|
>

org-collector is useful when you want to perform calculations on
properties *before* they are entered into a columnview type table.
Using org-collector a dblock like the following should work.

#+BEGIN: propview :cols (ITEM Quoted Sold (- Sold Quoted))
#+END:

The downside of org-collector is that it is not really part of org-mode,
and it doesn't have many of the nice features of columnview tables, like
the specification of column titles.  You can grab a copy of
org-collector.el from here
http://github.com/eschulte/org-contrib/raw/df909c94083b882d9a0f703a4314e034=
2dc5343f/org-collector.el

Cheers -- Eric