Count Sales for Project entries in Pie Chart

[michael_wernsing]

Hi guys,

I have a problem:

I use a diagram table where I show project numbers (calles "ID") and I count, if they have already sales or not.

For sales, I say:

if((Sum([revenue in EUR]) + sum([revenue in EUR V]))>0, '1','0')

if they don't have sales, I use this one:

=count(DISTINCT ID)-(if((Sum([revenue in EUR]) + sum([revenue in EUR V]))>0, '1','0'))

Both formulas work fine for the tables, but when I want to put this into an overview pie chart, it won't work.

Does anyone of you have an idea what I do wrong?

Thanks in advance,

Michael

[michael_wernsing]

Any help? I appreciate any suggestion!!