It’s a fairly common problem – you want to have a true record count in a Salesforce report.

But let’s say you have 4 accounts, each with 3 opportunities, then your record count is 12.

But hey, you want to know how many accounts are listed, not the number of records listed on the page, right?

I’ll admit it’s not such a big problem when you’re viewing 12 accounts but I’m often viewing many hundreds. Then one day, I came across The Power of One, and I’ve never looked back.

Here’s a step by step guide to creating it yourself.

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

add-to-page-layout

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.

PS – See our Ebsta for Salesforce Administrators page for more information on how Ebsta can revolutionise your Salesforce.


Share this post

You might also like...

Salesforce data quality
6th December 2017 | Sales and Marketing

5 Shocking Stats About Salesforce Data Quality

A customer relationship management (CRM) system like Salesforce provides many benefits for sales, marketing, and service teams such as having a better ability…

Read more ›
accurate-Salesforce-data
11th October 2017 | Stories

3 Sales KPIs that Require Accurate Salesforce Data

Just last week I was browsing the website and filling out forms to view content for a product that I…

Read more ›
sales-call
1st September 2017 | Sales and Marketing

Researching Your Prospect Before the Sales Call

Let’s face it, sales calls aren’t easy. Not only do you have to go through the pain of trying to…

Read more ›

Ready to drive customer engagement?