The Power Of One – Salesforce Hack

The power of salesforce one 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.

Optimize your entire sales operation

Build deeper relationships with customers across longer life cycles and identify the wider revenue risks and expedite opportunities in your pipeline.

  • This field is for validation purposes and should be left unchanged.