Re: [O] table formula help...

[Thierry Banel]

Le 07/12/2014 10:39, Michael Brand a écrit :
> Hi Thierry
>
>
> 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)
>

I didn't knew about the EN specifier. Thanks Michael for pointing to it.
Your suggestion is quite interesting. I will take a look.
We could also handle empty fields as zero.
Let us think about the best to do.