From mboxrd@z Thu Jan 1 00:00:00 1970 From: Nicolas Goaziou Subject: Re: problems with tables using https://orgmode.org/worg/org-tutorials/org-lookups.html Date: Tue, 01 May 2018 11:49:19 +0200 Message-ID: <874ljrk8o0.fsf@nicolasgoaziou.fr> References: <876055fxzs.fsf@mat.ucm.es> <87fu3cna23.fsf@nicolasgoaziou.fr> <87h8nsy8dh.fsf@mat.ucm.es> <87tvrslh0x.fsf@nicolasgoaziou.fr> <876047bukl.fsf@mat.ucm.es> Mime-Version: 1.0 Content-Type: text/plain Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:55634) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1fDRuZ-00013l-Fn for emacs-orgmode@gnu.org; Tue, 01 May 2018 05:49:28 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1fDRuW-0000b7-E1 for emacs-orgmode@gnu.org; Tue, 01 May 2018 05:49:27 -0400 Received: from relay2-d.mail.gandi.net ([217.70.183.194]:34993) by eggs.gnu.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.71) (envelope-from ) id 1fDRuW-0000aV-7L for emacs-orgmode@gnu.org; Tue, 01 May 2018 05:49:24 -0400 Received: from saiph (40-67.ipv4.commingeshautdebit.fr [185.131.40.67]) (Authenticated sender: admin@nicolasgoaziou.fr) by relay2-d.mail.gandi.net (Postfix) with ESMTPSA id 5A02440009 for ; Tue, 1 May 2018 11:49:21 +0200 (CEST) Received: from ngz by saiph with local (Exim 4.89) (envelope-from ) id 1fDRuR-0007av-S6 for emacs-orgmode@gnu.org; Tue, 01 May 2018 11:49:19 +0200 In-Reply-To: <876047bukl.fsf@mat.ucm.es> (Uwe Brauer's message of "Tue, 01 May 2018 11:20:58 +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 Hello, Uwe Brauer writes: > Here is the table I consider > > #+name: raw-data2 > |---+-----------------+-----+-----+-----+-----+-----+-----+-----| > > | | Nombre Completo | DNI | Ej1 | Ej2 | Ej3 | Ej4 | Ej5 | Res | > |---+-----------------+-----+-----+-----+-----+-----+-----+-----| > | | Candidate1 | 1 | 0 | 5 | 5 | 0 | 10 | 2 | > | | Candidate2 | 2 | 5 | 0 | 5 | 0 | 0 | 1 | > | | Candidate3 | 3 | 0 | 0 | 0 | 20 | 25 | 4.5 | > | | Candidate4 | 4 | 0 | 0 | 0 | 25 | 15 | 4 | > | | Candidate5 | 5 | 15 | 15 | 20 | 25 | 25 | 10 | > | | Candidate6 | 6 | 15 | 10 | 20 | 20 | 20 | 8.5 | > | | Candidate7 | 7 | 15 | 10 | 10 | 20 | 15 | 7 | > > #+TBLFM: $9=($4+$5+$6+$7+$8)/10 > > | lower bound | upper bound | frequency | > |-------------+-------------+-----------| > | 1 | 5 | #ERROR | > | 5 | 10 | #ERROR | > > #+TBLFM: $3='(length (org-lookup-all '($1 $2) '(remote(raw-data2,@2$9..@>$9)) nil 'in-interval));N > > I put the cursor on #+TBLFM: $3='(length (org-lookup-all '($1 $2) '(remote(raw-data2,@2$9..@>$9)) nil 'in-interval));N > > And run C-c C-c > I obtain an errror and the message I obtain: | lower bound | upper bound | frequency | |-------------+-------------+-----------| | 1 | 5 | 4 | | 5 | 10 | 3 | #+TBLFM: $3='(length (org-lookup-all '($1 $2) '(remote(raw-data2,@2$9..@>$9)) nil 'in-interval));N I have no explaination for the discrepancy. Regards, -- Nicolas Goaziou