How to Count Customers

  • Thread starter Thread starter Racer57
  • Start date Start date
R

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?
 
Thanks - that did it.

Fredg said:
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.


Racer57 said:
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?
Click to expand...
Click to expand...
 
Back
Top