Search Community
- Force.com Discussion Boards
- :
- Salesforce User Discussions
- :
- Best Practices Discussion
- :
- Re: Basic Question on reporting
turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic to the Top
- Bookmark
- Subscribe
- Printer Friendly Page
Basic Question on reporting
Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
10-31-2008 10:12 AM
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!
Thank you!
Re: Basic Question on reporting
Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
11-01-2008 09:37 PM
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

