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

How to Demonstrate ROI of Revenue Operations with Julian Hannabuss, Director of Revenue Operations at Procurify

In this episode of the Revenue Insights Podcast, host Lee Bierton is joined by Julian Hannabuss, Director of Revenue Operations at Procurify, a leading procurement and purchasing software company that lets teams track, control, and analyze all business spending so they can scale faster. Julian shares his insights on how revenue operations should present their revenue outcomes and can drive organizational value to the board. He also shares his insights on the difference between high and average performers in the sales and revenue teams. Julian shares some tips on how to mitigate churn at your company.

How to Build Your Pipeline Through Social Selling with Tim Hughes, CEO of DLA Ignite

In this episode of the Revenue Insights Podcast, host Lee Bierton is joined by Timothy Hughes, CEO of DLA Ignite, a strategic advisory and consultancy enterprise that enables organizations to leverage social selling to convert pipeline leads. Tim shares a three-step social selling process to build pipeline leads and highlights how conversations rather than content play a pivotal role in the conversion process. Conversions pivot around educating the prospects on their pain areas and then offering solutions to resolve the issues. The episode is also a gold mine for sales leaders looking for insights that are easy to adopt and implement.

The Four-Step Framework to Reimagine Sales Teams with Ben Stroup, President at Velocity Strategy Solutions

In this episode of the Revenue Insights Podcast, host Lee Bierton is joined by Ben Stroup, President at Velocity Strategy Solutions, an on-demand strategy and management consulting firm. Ben shares his insights on how Velocity uses people, processes, technology, and data to reimagine sales and revenue teams, and move the needle toward a modern-day revenue operation and management approach. Companies must move from monitoring lagging indicators like revenue to analyzing leading indicators like customer acquisition costs (CAC) and customer lifetime value (LTV). Ben also touches on the importance of aligning internal teams to a common goal.