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 10:55:56 +0100
Message-ID: <5484242C.2060309@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]:49510)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <tbanelwebmin@free.fr>) id 1XxYZU-0007ZR-7r
	for emacs-orgmode@gnu.org; Sun, 07 Dec 2014 04:56:14 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <tbanelwebmin@free.fr>) id 1XxYZK-0002Zw-QS
	for emacs-orgmode@gnu.org; Sun, 07 Dec 2014 04:56:08 -0500
Received: from smtp4-g21.free.fr ([212.27.42.4]:1643)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <tbanelwebmin@free.fr>) id 1XxYZK-0002YS-L5
	for emacs-orgmode@gnu.org; Sun, 07 Dec 2014 04:55:58 -0500
Received: from [IPv6:2a01:e35:2e21:def0:945c:654d:e692:22ed] (unknown
	[IPv6:2a01:e35:2e21:def0:945c:654d:e692:22ed])
	by smtp4-g21.free.fr (Postfix) with ESMTP id 702A64C8097
	for <emacs-orgmode@gnu.org>; Sun,  7 Dec 2014 10:55:34 +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)
>

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.