Hello, Uwe Brauer <o...@mat.ucm.es> 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
