[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [O] table formula help...
From: |
Michael Brand |
Subject: |
Re: [O] table formula help... |
Date: |
Sun, 7 Dec 2014 10:39:58 +0100 |
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)
- Re: [O] table formula help..., (continued)
- Re: [O] table formula help..., Michael Brand, 2014/12/07
- Re: [O] table formula help..., Thierry Banel, 2014/12/07
- Re: [O] table formula help..., Michael Brand, 2014/12/07
- Re: [O] table formula help..., Thierry Banel, 2014/12/07
- Re: [O] table formula help..., Thierry Banel, 2014/12/07
- Re: [O] table formula help..., Michael Brand, 2014/12/07
- Re: [O] table formula help..., Thierry Banel, 2014/12/08
- Re: [O] table formula help..., Thierry Banel, 2014/12/08
- Re: [O] table formula help..., Michael Brand, 2014/12/10
- Re: [O] table formula help..., Eric Abrahamsen, 2014/12/07
- Re: [O] table formula help...,
Michael Brand <=
- Re: [O] table formula help..., Thierry Banel, 2014/12/07
- Re: [O] table formula help..., Thierry Banel, 2014/12/07
- Re: [O] table formula help..., Michael Brand, 2014/12/08
- Re: [O] table formula help..., Thierry Banel, 2014/12/08
- Re: [O] table formula help..., Michael Brand, 2014/12/09
- Re: [O] table formula help..., Thierry Banel, 2014/12/09
- Re: [O] table formula help..., Thierry Banel, 2014/12/09
- Re: [O] table formula help..., Thierry Banel, 2014/12/09
- Re: [O] table formula help..., Michael Brand, 2014/12/10
- Re: [O] table formula help..., Thierry Banel, 2014/12/10