From mboxrd@z Thu Jan  1 00:00:00 1970
From: Michael Brand <michael.ch.brand@gmail.com>
Subject: Re: table formula help...
Date: Sun, 7 Dec 2014 10:39:58 +0100
Message-ID: <CALn3zoj-7zhTNtiE+TsZrxi2ibuQUe=vJX-_UBOiENZ8hf69Aw@mail.gmail.com>
References: <87ppbxfi5f.fsf@ericabrahamsen.net>
	<CALn3zogy-J5cSHUgOHmxpN2UH=g54QcU2=pqyAMGgMf1Pcd6Jg@mail.gmail.com>
	<54838805.8090705@free.fr> <8761do6t01.fsf@ericabrahamsen.net>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:48039)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1XxYJt-0004lD-Gl
	for emacs-orgmode@gnu.org; Sun, 07 Dec 2014 04:40:02 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1XxYJs-00057W-H3
	for emacs-orgmode@gnu.org; Sun, 07 Dec 2014 04:40:01 -0500
Received: from mail-qa0-x22d.google.com ([2607:f8b0:400d:c00::22d]:43284)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1XxYJs-00057B-D8
	for emacs-orgmode@gnu.org; Sun, 07 Dec 2014 04:40:00 -0500
Received: by mail-qa0-f45.google.com with SMTP id x12so2240519qac.32
	for <emacs-orgmode@gnu.org>; Sun, 07 Dec 2014 01:39:58 -0800 (PST)
In-Reply-To: <8761do6t01.fsf@ericabrahamsen.net>
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: Thierry Banel <tbanelwebmin@free.fr>
Cc: Org Mode <emacs-orgmode@gnu.org>

Hi Thierry

On Sun, Dec 7, 2014 at 4:25 AM, Eric Abrahamsen <eric@ericabrahamsen.net> wrote:
> Thierry Banel <tbanelwebmin@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)