Hi Thierry On Sun, Dec 7, 2014 at 4:25 AM, Eric Abrahamsen <e...@ericabrahamsen.net> wrote: > Thierry Banel <tbanelweb...@free.fr> writes: >> [...] >> #+BEGIN: aggregate :table "work" :cols "Translator sum(Chars) sum(Lines)" >> | Translator | sum(Chars) | sum(Lines) | >> >> |-----------------+------------+------------| >> | Austin Woerner | NA | 84 | >> | Eric Abrahamsen | 6633 | NA | >> | Canaan Morse | 16984 | NA | >> | Lucas Klein | 2 NA | 34 | >> #+END: >> [...] > I've changed blank fields to "0" so that I don't get the "NA" strings. >> [...]
I suggest that orgaggregate leaves such fields empty instead of "NA". This way the user gets a choice how to deal with them by adding e. g. EN or not as TBLFM format specifier: | Translator | sum(Chars) | sum(Lines) | |-----------------+------------+------------| | Austin Woerner | | 84 | | Eric Abrahamsen | 6633 | | | Canaan Morse | 16984 | | | Lucas Klein | | 34 | |-----------------+------------+------------| | | 5904.25 | 59 | #+TBLFM: @>$2 = vmean(@I..@II); EN :: @>$3 = vmean(@I..@II)
