Count when invoiced

[Femke_DPG]

Hello

How can I count the amount of offer numbers that have an invoice number? So in this example it has to be 2:

There are 3 offer numbers, but 2 of them are invoiced. 

I've tried this

if(isnull([Invoice: Invoice]),null(),count (distinct [Offer Number]))

but did not get the right result because it does not count DISTINCTS. It says 4 but has to be 2

Thanks for your help! 

[sergio0592 · Accepted solution]

Hi,

In a text box, try with :

=count(distinct {<Invoice={">0"}>}  Offer_number)

In a straight table , in the expression :

=aggr(count(distinct {<Invoice={">0"}>}  Offer_number),Offer_number)

[brunobertels]

hi 

may be 

count ({<[Invoice: Invoice]-={null()}>}distinct [Offer Number]))

or

count ({<[Invoice: Invoice]-={'-'}>}distinct [Offer Number]))

or 

count ({<[Invoice: Invoice]-={'*'}>}distinct [Offer Number]))