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.