0

I have a table I'm generating:

#+BEGIN: clocktable :maxlevel 0 :block thisyear :scope get-journal-files-for-current-year :fileskip0 t
#+CAPTION: Clock summary at [2021-05-19 Wed 20:31], for the year 2021.
| File         | Headline         | Time     |
|--------------+------------------+----------|
|              | ALL *Total time* | *178:27* |
|--------------+------------------+----------|
| 16_04-19.org | *File time*      | *38:18*  |
|--------------+------------------+----------|
| 17_04-26.org | *File time*      | *38:32*  |
|--------------+------------------+----------|
| 18_05-03.org | *File time*      | *38:07*  |
|--------------+------------------+----------|
| 19_05-10.org | *File time*      | *39:46*  |
|--------------+------------------+----------|
| 20_05-17.org | *File time*      | *23:44*  |
#+END:

I would like to get the average of all the rows in the Time column (excluding the 178:27 one). I can do this with a regular formula, say =vmean(@3$3..@7$3);T under the cell with 23:44 in it. I tried to do this with the formula: paramater to the clocktable, but I'm unable to do get exactly the behavior I want.

If I try formula: "@8$3=vmean(@3$3..@7$3);T", I get an org-clocktable-write-default: Args out of range: [nil 0 2 4 6 8 10 12], 8 error.

If I do :formula "$4=vmean(@3$3..@7$3);T", I get the right values, but in every row in the fourth column (and if I try to do ...@>=$3, to get all the rows in the third column, I just get a blank column.)

How do I get a single cell with the average for the third column in it that excludes the 178:27 cell?

Thank you.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.