From mboxrd@z Thu Jan 1 00:00:00 1970 From: Alan L Tyree Subject: Help with org-lookup-all Date: Wed, 03 Sep 2014 11:24:32 +1000 Message-ID: <54066DD0.60608@gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:45621) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1XOzJT-0004sn-HA for emacs-orgmode@gnu.org; Tue, 02 Sep 2014 21:24:48 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1XOzJO-0005UD-T2 for emacs-orgmode@gnu.org; Tue, 02 Sep 2014 21:24:43 -0400 Received: from mail-pa0-x22b.google.com ([2607:f8b0:400e:c03::22b]:34301) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1XOzJO-0005U7-Lm for emacs-orgmode@gnu.org; Tue, 02 Sep 2014 21:24:38 -0400 Received: by mail-pa0-f43.google.com with SMTP id et14so16197961pad.2 for ; Tue, 02 Sep 2014 18:24:36 -0700 (PDT) Received: from [192.168.1.1] (202.63.32.163.static.rev.eftel.com. [202.63.32.163]) by mx.google.com with ESMTPSA id qy10sm5213016pbb.47.2014.09.02.18.24.34 for (version=TLSv1.2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Tue, 02 Sep 2014 18:24:35 -0700 (PDT) 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-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: emacs-orgmode I feel so dumb! I have this expession attached to a table: (org-lookup-all $1 '(remote(payments,@2$4..@>$4)) '(remote(payments,@2$2..@>$2))) It is returning the right list of numbers since I can examine them with (nth n .... How do I add the list up? I keep getting #ERROR or obviously wrong answers. What I want is something like $2='(apply '+ (org-lookup-all $1 '(remote(payments,@2$4..@>$4)) '(remote(payments,@2$2..@>$2)))) but that gives me errors since (I presume) the list is a bunch of strings. Thanks for any help, Alan -- Alan L Tyree http://www2.austlii.edu.au/~alan Tel: 04 2748 6206 sip:typhoon@iptel.org