From mboxrd@z Thu Jan  1 00:00:00 1970
From: Thierry Banel <tbanelwebmin@free.fr>
Subject: Re: table formula help...
Date: Sun, 07 Dec 2014 22:57:48 +0100
Message-ID: <5484CD5C.9070604@free.fr>
References: <87ppbxfi5f.fsf@ericabrahamsen.net>	<CALn3zogy-J5cSHUgOHmxpN2UH=g54QcU2=pqyAMGgMf1Pcd6Jg@mail.gmail.com>	<54838805.8090705@free.fr>	<8761do6t01.fsf@ericabrahamsen.net>
	<CALn3zoj-7zhTNtiE+TsZrxi2ibuQUe=vJX-_UBOiENZ8hf69Aw@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:44762)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <tbanelwebmin@free.fr>) id 1Xxjpy-0004Fc-3j
	for emacs-orgmode@gnu.org; Sun, 07 Dec 2014 16:57:54 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <tbanelwebmin@free.fr>) id 1Xxjpu-0002mT-RC
	for emacs-orgmode@gnu.org; Sun, 07 Dec 2014 16:57:54 -0500
Received: from smtp3-g21.free.fr ([2a01:e0c:1:1599::12]:37284)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <tbanelwebmin@free.fr>) id 1Xxjpu-0002m2-KN
	for emacs-orgmode@gnu.org; Sun, 07 Dec 2014 16:57:50 -0500
Received: from [IPv6:2a01:e35:2e21:def0:83d:e440:ccd6:614e] (unknown
	[IPv6:2a01:e35:2e21:def0:83d:e440:ccd6:614e])
	by smtp3-g21.free.fr (Postfix) with ESMTP id 24952A62B2
	for <emacs-orgmode@gnu.org>; Sun,  7 Dec 2014 22:57:23 +0100 (CET)
In-Reply-To: <CALn3zoj-7zhTNtiE+TsZrxi2ibuQUe=vJX-_UBOiENZ8hf69Aw@mail.gmail.com>
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: Org Mode <emacs-orgmode@gnu.org>

Le 07/12/2014 10:39, Michael Brand a =C3=A9crit :
> 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 =3D vmean(@I..@II); EN :: @>$3 =3D vmean(@I..@II)
>

Done.
Probably this can be discussed further.
For the time being, there is no longer any "NA".