fbpx The Power Of One - A Salesforce Admin Hack | Ebsta

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...

17th May 2019 | Sales Ops Demystified

Sales Operations Demystified: Mohit Bhargava

Webinar Recording of Sales Ops Demystified: Mohit Bhargava of a Big Tech Company Missed the Webinar? Want to rewatch previous…

Read more ›
14th May 2019 | Sales Ops Demystified

Sales Ops Demystified: Joe Gates of Spendesk

Webinar Recording of Sales Ops Demystified: Joe Gates of Spendesk Missed the Webinar? Want to rewatch previous webinars?…… Find out…

Read more ›
10th May 2019 | Sales Ops Demystified

Sales Ops Demystified: Jeffrey Serlin of Intercom

Webinar Recording of Sales Ops Demystified: Jeffrey Serlin of Intercom Missed the Webinar? Want to rewatch previous webinars?…… Find out…

Read more ›

Ready to drive revenue and retention?