Re: [O] table formula help...

[Thierry Banel]

Le 08/12/2014 19:02, Michael Brand a écrit :
> #+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