Count Sales for Project entries in Pie Chart

michael_wernsing — Wed, 22 Dec 2021 16:28:40 GMT

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

Re: Count Sales for Project entries in Pie Chart

michael_wernsing — Wed, 11 Aug 2021 05:58:30 GMT

Any help? I appreciate any suggestion!!