From mboxrd@z Thu Jan 1 00:00:00 1970 From: Karl Voit Subject: Calculate differences of remote table numbers Date: Mon, 1 Oct 2018 17:01:08 +0200 Message-ID: <2018-10-01T16-59-13@devnull.Karl-Voit.at> Reply-To: Karl Voit Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:50531) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1g6zhT-0005f1-Nf for emacs-orgmode@gnu.org; Mon, 01 Oct 2018 11:01:38 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1g6zhN-00085j-Qi for emacs-orgmode@gnu.org; Mon, 01 Oct 2018 11:01:31 -0400 Received: from [195.159.176.226] (port=48936 helo=blaine.gmane.org) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_128_CBC_SHA1:16) (Exim 4.71) (envelope-from ) id 1g6zhL-00083y-Sg for emacs-orgmode@gnu.org; Mon, 01 Oct 2018 11:01:24 -0400 Received: from list by blaine.gmane.org with local (Exim 4.84_2) (envelope-from ) id 1g6zf7-0007ZM-Eh for emacs-orgmode@gnu.org; Mon, 01 Oct 2018 16:59:05 +0200 List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Sender: "Emacs-orgmode" To: emacs-orgmode@gnu.org Hi! I'd like to calculate the differences between rows of numbers of a different table. Here is a minimal example showing the issue: #+NAME: my-table | Numbers | |---------| | 1 | | 5 | | 8 | | 12 | | 15 | This is what I expected: "exp. Reference1" and "exp. Reference2" is here only to demonstrate that the assumed references are wrong in the third table. "exp. Difference" is the column I want to get in the first place. I don't want to see Reference 1 or 2 at all in my solution (since I need a couple of those difference-columns). | Line | exp. Reference1 | exp. Reference2 | exp. Difference | |------+-----------------+-----------------+-----------------| | 1 | 0 | 0 | 0 | | 2 | 5 | 1 | 4 | | 3 | 8 | 5 | 3 | | 4 | 12 | 8 | 4 | | 5 | 15 | 12 | 3 | This is what I get instead: | Line | actual Reference1 | actual Reference2 | Difference | |------+-------------------+-------------------+------------| | 1 | 0 | 0 | 0 | | 2 | 6 | 1 | 5 | | 3 | 12 | 1 | 11 | | 4 | 20 | 1 | 19 | | 5 | 30 | 1 | 29 | #+TBLFM: $2=if(2 == @#, 0, remote(my-table,@#$1))::$3=if(2 == @#, 0, remote(my-table,@#-1$1))::$4=if(2 == @#, 0, (remote(my-table,@#$1)-remote(my-table,@#-1$1))) As you can see, the "actual Reference1" are not the values from the first column above (except the first one). "actual Reference2" is not the shifted column 1 from above (except the first one). I have no clue, what these numbers are. Maybe you can help me (1) explaining what the numbers in actual Reference1 and actual Reference2 are showing and (2) how to get the result ("expected Difference"; without explicitly generating Reference 1 or 2). Thanks! -- get mail|git|SVN|photos|postings|SMS|phonecalls|RSS|CSV|XML into Org-mode: > get Memacs from https://github.com/novoid/Memacs < Personal Information Management > http://Karl-Voit.at/tags/pim/ Emacs-related > http://Karl-Voit.at/tags/emacs/