From mboxrd@z Thu Jan  1 00:00:00 1970
From: Thierry Banel <tbanelwebmin@free.fr>
Subject: Re: table formula help...
Date: Tue, 09 Dec 2014 20:01:49 +0100
Message-ID: <5487471D.5070807@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>	<5484CD5C.9070604@free.fr>
	<CALn3zoja2+16+bXkSi9psyS1Lj0q-L7Q2xD+TJTYYsGfkkhvHg@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]:35283)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <tbanelwebmin@free.fr>) id 1XyQ2m-0006DB-Kl
	for emacs-orgmode@gnu.org; Tue, 09 Dec 2014 14:02:01 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <tbanelwebmin@free.fr>) id 1XyQ2h-0006Fq-JC
	for emacs-orgmode@gnu.org; Tue, 09 Dec 2014 14:01:56 -0500
Received: from smtp5-g21.free.fr ([212.27.42.5]:19680)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <tbanelwebmin@free.fr>) id 1XyQ2h-0006Fa-9Z
	for emacs-orgmode@gnu.org; Tue, 09 Dec 2014 14:01:51 -0500
Received: from [IPv6:2a01:e35:2e21:def0:c90f:b89b:d367:7611] (unknown
	[IPv6:2a01:e35:2e21:def0:c90f:b89b:d367:7611])
	by smtp5-g21.free.fr (Postfix) with ESMTP id 28832D48072
	for <emacs-orgmode@gnu.org>; Tue,  9 Dec 2014 20:00:30 +0100 (CET)
In-Reply-To: <CALn3zoja2+16+bXkSi9psyS1Lj0q-L7Q2xD+TJTYYsGfkkhvHg@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 08/12/2014 19:02, Michael Brand a =C3=A9crit :
> #+TBLNAME: original
> | Item | Value |
> |------+-------|
> | a2   |     1 |
> | a2   |     1 |
> | a0   |    -1 |
> | a0   |     1 |
> | b2   |     2 |
> | b2   |       |
> | b0   |     0 |
> | b0   |       |
> | c    |       |
> | c    |       |
>
> #+BEGIN: aggregate :table original :cols "Item sum(Value) mean(Value)"
> | Item | sum(Value) | mean(Value) |
> |------+------------+-------------|
> | a2   |          2 |           1 |
> | a0   |            |             |
> | b2   |          2 |           1 |
> | b0   |            |             |
> | c    |            |             |
> #+END
>
> Could you please add this example or something in the same sense to
> the unittests.org before any other change?
>

Done under the title "* Test zero output".
There is also a new "* Test empty inputs" were several empty input cases
are tested against all the available aggregations (sum, mean, max, corr,
and so on).

I will work on a new and clean design for handling empty inputs.
It shouldn't be so difficult after all.
Stay tuned.

Have fun
Thierry