From mboxrd@z Thu Jan 1 00:00:00 1970 From: "Sebastien Vauban" Subject: Referencing a cell from a clockview table looks impossible Date: Tue, 20 Mar 2012 12:29:07 +0100 Message-ID: <80zkbb1pfg.fsf@somewhere.org> Mime-Version: 1.0 Content-Type: text/plain Return-path: 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-mXXj517/zsQ@public.gmane.org Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org-mXXj517/zsQ@public.gmane.org To: emacs-orgmode-mXXj517/zsQ@public.gmane.org Hello, I need to access to the "Total time" cell of a clocktable view. I've named it properly, but references to a given cell all return "#ERROR". * Work Some tasks with CLOCK lines, for showing the problem. ** TODO Do this :LOGBOOK: CLOCK: [2012-03-19 Mon 09:00]--[2012-03-19 Mon 10:11] => 1:11 :END: ** TODO Do that :LOGBOOK: CLOCK: [2012-03-20 Tue 10:00]--[2012-03-20 Tue 12:22] => 2:22 :END: * Report ** Dynamic block The dynamic block captures the fact that I've worked 1:11 hours yesterday, on some task of this file. #+TBLNAME: hours-yesterday #+BEGIN: clocktable :maxlevel 4 :scope file :block yesterday Clock summary at [2012-03-20 Tue 11:59], for Monday, March 19, 2012. | Headline | Time | | |--------------+------+------| | *Total time* | *1:11* | | |--------------+------+------| | Work | 1:11 | | | TODO Do this | | 1:11 | #+END: ** Table with remote reference As I need the above time to be converted first to a float, then to money, I'm using a remote reference to the above "Total Time", and a table which shows the intermediate results: | Tasks | HH:MM | Float | USD | |-----------+--------+-------+--------| | Yesterday | #ERROR | 0.00 | #ERROR | |-----------+--------+-------+--------| | | | 0. | 0 | #+TBLFM: $3='(/ (float (org-hh:mm-string-to-minutes $2)) 60.);%.2f::$4=$2*30::@2$2=remote(hours-yesterday,@2$2)::@3$3=vsum(@-I..@-II) But the remote reference fails with whichever referenced cell. Any idea? Best regards, Seb -- Sebastien Vauban