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.

Posted in

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

Share this article

Related Content

Bringing Revenue Intelligence to Salesforce

Have you ever tried to build furniture without the instructions? You can follow your gut and may end up with…

4 changes to improve your sales forecasting process

This blog covers the main symptoms that result in forecasting inaccuracy, some quick fixes to improve your sales forecasting, and some more significant changes.

The Secret To Rapid Growth: Sales Process Optimization

6 steps to find the levers that unlock exponential growth. Understand how win/loss analysis can transform your business.