Aggregation as Expression Returnes Only Zeors

Wed, 15 Oct 2014 10:20:25 GMT

Hi,

The best way to explain my problem is with the example I attached:

Each day I get apples from more than one client.

I also know, for each day and client, what is the percentage of bad apples I got from him.

I want to chart the total number of bad apples I got from the selected client (if none then all).

I've tried to do so with a line chart, where the dimension is the date and the expression is:

sum(aggr((PercentOfBadApples/100)*NumOfApples,Client))

But for some reason it returns only zeros.

Even more weird is that when I choose only one date, it returns the right value!

What can I do so it would return the right result?

Thanks!

Re: Aggregation as Expression Returnes Only Zeors

anbu1984 — Wed, 15 Oct 2014 10:29:33 GMT

sum((PercentOfBadApples/100)*NumOfApples)