Reply
Regular Contributor
Cafe
Posts: 47

Basic Question on reporting

It seems like there should be an easy way to do this, but I can't figure it out. I'm trying to create a report that shows totals of various aspects of our account data. I would like to show of the total number of accunts we have, the number of contacts within those accounts, the number that we have email addresses for, and various other aspects. The only thing I am able to total with the Standard Summary Fields is the record count. This totals the number of contacts, but nothing else. I have summarized by account, so I can see how many contacts per account, but not the number of accounts. Is there a way I can add more standard summary fields?

Thank you!
Trusted Contributor
rpr2
Posts: 440

Re: Basic Question on reporting

I also wanted to have a count of how many of our contacts have email addresses.  Here's how I did it.  I created a custom field on the contact called "Has email address" and made it a numeric formal (0 decimal places).  The formula I used is: 

if (len(Email)=0,0,1)

This will put a 0 in the field if there isn't an email address, and a 1 if there is.  Then you can do a sum on this field to get your count.  You could also do summaries to find the % with email addresses, if desired.

Rhonda