Distinct records 1

[SAWB]

I have a report that lists invoice numbers
if the invoice total is a between a certain
amount (100-500, 500-1000, etc).
When I do a distinct count summary in that group, I get
one more than there actually is.
Example: If there is no invoices, it totals 1
If there is 1 invoice, it totals 1
If there are 5 invoices, it totals 6
etc...
How do I tell the summary to not count the blank
invoice numbers?

 

[IdoMillet]

SAWB,

Create a formula field that returns
1 or 0 based on the condition you are
using.

Then SUM that field.

Cheers,
- Ido

 

[SAWB]

That was too simple...I was looking for something harder.

Thanks