Re: [O] table formula help...

[Michael Brand]

Hi Thierry

On Sun, Dec 7, 2014 at 4:25 AM, Eric Abrahamsen <address@hidden> wrote:
> Thierry Banel <address@hidden> 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(@address@hidden); EN :: @>$3 = vmean(@address@hidden)