How to Count Customers

[Racer57]

I have a Report that is grouped by construction project. Each construction
project builds services to a variable number of customers. If a customer
buys our service, I enter the monthly revenue amount in a field called
Revenue.
I want to be able to determine how many of those customers actually buy our
service, for each project, by counting how many customers have revenue >
$0.00

For example, Project A builds services to 20 customers. Of those 20
customers, only 10 buy our service. So I enter the revenue amount for each
customer in the revenue field. I have tried =count([Revenue>0], but that
returns the same number as =count(*).

Any ideas on this?

 

[Fredg]

In the Group Header or Group Footer:

=Sum(IIf([Revenue]>0,1,0))

 

[Racer57]

Thanks - that did it.

In the Group Header or Group Footer:

=Sum(IIf([Revenue]>0,1,0))

--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.

I have a Report that is grouped by construction project. Each construction
project builds services to a variable number of customers. If a customer
buys our service, I enter the monthly revenue amount in a field called
Revenue.
I want to be able to determine how many of those customers actually buy our
service, for each project, by counting how many customers have revenue >
$0.00

For example, Project A builds services to 20 customers. Of those 20
customers, only 10 buy our service. So I enter the revenue amount for each
customer in the revenue field. I have tried =count([Revenue>0], but that
returns the same number as =count(*).

Any ideas on this?