Aggregation as Expression Returnes Only Zeors

[#1]

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!

[anbu1984]

sum((PercentOfBadApples/100)*NumOfApples)