From mboxrd@z Thu Jan  1 00:00:00 1970
From: Cecil Westerhof <cldwesterhof@gmail.com>
Subject: Difference between two rows
Date: Sun, 1 Jun 2014 13:38:56 +0200
Message-ID: <CAG-LmmDoDUaKnPqiBzVsmJKnLB80cWwJdT6WnTovZsibh2efNg@mail.gmail.com>
Mime-Version: 1.0
Content-Type: multipart/alternative; boundary=001a1134aeb44ebde904fac4b9ae
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:47475)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <cldwesterhof@gmail.com>) id 1Wr46L-000419-Ru
	for emacs-orgmode@gnu.org; Sun, 01 Jun 2014 07:38:58 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <cldwesterhof@gmail.com>) id 1Wr46L-0007vq-1V
	for emacs-orgmode@gnu.org; Sun, 01 Jun 2014 07:38:57 -0400
Received: from mail-qa0-x235.google.com ([2607:f8b0:400d:c00::235]:36874)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <cldwesterhof@gmail.com>) id 1Wr46K-0007vk-TA
	for emacs-orgmode@gnu.org; Sun, 01 Jun 2014 07:38:56 -0400
Received: by mail-qa0-f53.google.com with SMTP id x12so1211166qac.26
	for <emacs-orgmode@gnu.org>; Sun, 01 Jun 2014 04:38:56 -0700 (PDT)
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: emacs-orgmode@gnu.org

--001a1134aeb44ebde904fac4b9ae
Content-Type: text/plain; charset=UTF-8

I like to calculate in a table the difference between the value in a field
in the current row and the previous field. How would I do that?

Something like:
|-------+------------|
| value | difference |
|-------+------------|
|    12 |            |
|    15 |          3 |
|    83 |         68 |
|    87 |          4 |
|    85 |         -2 |
|-------+------------|


-- 
Cecil Westerhof

--001a1134aeb44ebde904fac4b9ae
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div class=3D"gmail_default" style=3D"font-family:courier =
new,monospace">I like to calculate in a table the difference between the va=
lue in a field in the current row and the previous field. How would I do th=
at?<br>
<br></div><div class=3D"gmail_default" style=3D"font-family:courier new,mon=
ospace">Something like:<br></div><div class=3D"gmail_default" style=3D"font=
-family:courier new,monospace">|-------+------------|<br>| value | differen=
ce |<br>
|-------+------------|<br>|=C2=A0=C2=A0=C2=A0 12 |=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 |<br>|=C2=A0=C2=A0=C2=A0 15 |=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 3 |<br>|=C2=A0=C2=A0=C2=
=A0 83 |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 68 |<br>|=C2=A0=C2=
=A0=C2=A0 87 |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 4 |<br=
>|=C2=A0=C2=A0=C2=A0 85 |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 -=
2 |<br>|-------+------------|<br><br clear=3D"all"></div><br>-- <br>Cecil W=
esterhof
</div>

--001a1134aeb44ebde904fac4b9ae--