The Power Of One – Salesforce Hack

The Problem
There are 2 accounts listed below, but the Grand Total is 4. How do I summarize the number of unique account records?
account-list-salesforce

Go to App Setup (you’ll need to be an admin) and select Accounts and then Fields:

App-Setup-Salesforce

Click ‘New’ under Account Custom Fields section:

Account-Custom-Fields-section

Select Data Type as ‘Formula’ and click Next:

Data-Type-Salesforce

Give your new field a name, select ‘Number’ and then press Next:

name-field-salesforce

Enter the figure ‘1’ in the formula field and click Next:

formula-salesforce

Unselect the Add to page layout option and hit Save.

Go to “customize” your accounts report. Add your new field (AccNo) as a column. Select the “Summarize this Field” option as shown below:

customize-accounts-report-salesforce"Select “Sum” and then “Apply”:

sum-and-apply-salesforce

Run your report and hey presto, the number of unique account records is shown at the foot of the column:

salesforce-unique-account-records

Tip

I’ve created a custom formula field that displays the Account AccNo field shown above on the Opportunity object.
That allows me to create an Opportunity report, put AccNo as a column, summarize that column and see the true Account record count when I run Opportunity reports. It’s worth mentioning you can use the Power of One on any object.

About the Author

Avatar for Costin Botez

Costin Botez

Speak with our experts and see how Ebsta will help improve your sales

New call-to-action
New call-to-action
Logo Icon (White)@2x

Newsletter Signup

Sign up to our newsletter for monthly specials and blog updates.

Share this article

Related Content

Top 5 Highlights From Dreamforce 2019

With 171,000 registered attendees, 2,700 different sessions and 13 million online viewers, Dreamforce was back with a bang in 2019.…

How These Top 5 Salesforce Adoption Hacks Save Time and Money

Businesses often purchase Salesforce as a panacea for all their sales ills; when it doesn’t deliver the results right away, executives and managers are often left with an enterprise-level solution without the enterprise results and tragically low Salesforce adoption

The Role Of The Salesforce Administrator

Salesforce Administrators When we got down to the bare bones of it

Ready to get started?

New call-to-action
New call-to-action