Set analysis

[#1]

Hi!

I have some problems with set analysis. How do I do it?

I want to count the "Personnr" if count(distinct InvoiceNo)=0.

I tried do write it like this (but error):

count({$<count(distinct InvoiceNo)={0}>} Personnr)

Can you help me?

/Julia

[swuehl · Accepted solution]

If I understood your request correctly, maybe like this:

count({$<Personnr = {"=count(distinct InvoiceNo)=0"} >} DISTINCT Personnr)

[Gysbert_Wassenaar]

Isn't that a count of Personnr without invoices:

count({$<InvoiceNo-={'*'}>} Personnr)

btw, the editor doesn't understand -= ,but it works nonetheless

[#4]

Thanks!

[#5]

Thanks