Suppose I have some headlines that look like this.
* TODO Parent
** TODO Sub Head1
CLOCK: [2015-02-09 Mon 07:00]--[2015-02-09 Mon 07:08] => 0:08
*** TODO Sub Sub Head
CLOCK: [2015-02-09 Mon 19:20]--[2015-02-09 Mon 19:24] => 0:04
** TODO Sub Head2
CLOCK: [2015-02-09 Mon 07:08]--[2015-02-09 Mon 07:11] => 0:03
Now, if I have a clock table report defined like this.
#+BEGIN: clocktable :maxlevel 2 :scope file :formula "$4='(random)::@2$4='(vsum @3$4)"
I have a custom formula that computes a value. To illustrate my problem, I've used (random) as a way to populate a column. How do I then sum up the results?
| Headline | Time | | |
|--------------------+--------+------+---------------------|
| *Total time* | *0:15* | | #ERROR |
|--------------------+--------+------+---------------------|
| TODO Parent | 0:15 | | 796400794509121126 |
| \__ TODO Sub Head1 | | 0:12 | 2086072072269781784 |
| \__ TODO Sub Head2 | | 0:03 | 1733653844633948893 |
I've used the formula debugger C-f { and I can see that my vsum invocation is receiving the cell values as propertized strings. Is there a way to compute that sum and lay it down in that cell where the #ERROR resides?