I have been using Bernt Hansen's org-mode setup (http://doc.norang.ca/org-mode.html - modified slightly to my needs) for some time and I came up with a question that I cannot solve.

I would like to add a colunn to my clock table report showing the percentage of each group of activities. The attached is an example of a typical clock table report. I would like to add a column next to Time showing the percentage of time spent in nonValueAdded.org (i.e., 16.59=100*(1:13/7:20)), service.org, teaching.org.

After reading Use formula in agenda clockreport to convert time? (pomodoro count in Agenda), I tried adding :formula "$4=(%CLOCKSUM/%CLOCKSUM_T)*(100);t" as below

(setq org-agenda-clockreport-parameter-plist
  (quote (:link t :maxlevel 5 :fileskip0 t :compact t :narrow 80 :formula "$4=(%CLOCKSUM/%CLOCKSUM_T)*(100);t")))

but it was not successful.

I appreciate any help on this.


enter image description here

1 Answer 1


The formula is quite simple ;)

(setq org-agenda-clockreport-parameter-plist
      (quote (:link t :maxlevel 5 :fileskip0 t :compact t :narrow 80 :formula %)))
  • Thanks mutbuerger! It worked perfectly. Couldn't guess it would be that simple though :)
    – Logici
    Jul 9, 2015 at 14:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.