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
