Salesforce reports allow users to analyze data, gain insights, and make informed decisions. While standard reports provide valuable information out-of-the-box, there are times when you need to perform more complex calculations or manipulate data in ways that standard reports can’t accomplish. This is where report formulas come into play.
Report formulas in Salesforce are a vital tool for customizing and enhancing your reports. They allow you to perform calculations, create new fields, and apply conditional logic to your report data.
Whether you need to calculate sales margins, determine lead conversion rates, or segment data based on specific criteria, report formulas provide the flexibility to tailor your reports to your organization’s unique needs.
In this guide, we will explore the fundamentals of using report formulas in Salesforce.
Youtube Video
Before we jump too far into the post I want to mention that there is a corresponding youtube video on the Salesforce Emily youtube channel.
I will embed that here but keep scrolling to get to the good stuff!
Step by Step Tutorial
The first thing you’ll need to do is set up your report or go into a report you’ll be creating the summary field for.
For this tutorial, we will be starting from an already set report.
First, under the fields on the left side click “+ create formula”.
This will bring a pop up for you to edit your formula with.
Enter in the the metadata that you’ll need.
Here I’ve added a column name as ‘anticipated commission’, which is what we will be calculating here.
It can also be helpful to add a description to allow other salesforce users and admins to understand more about the field.
Next create your field formulas.
For this we are going to create the anticipated commission from a percentage of expected revenue.
So search for the expected revenue field and click it.
Next select insert the expected revenue to the editing area.
Then add in the rest of the formula, here we are are multiplying expected revenue amount by 0.02 which is the 2% commission rate in the scenario.
Once satisfied with the formula click validate and then apply!
You will be able to see your completed field on the report!
Conclusion
A big congrats to you for making it through this blog post! We hope you found it useful!
Check out the Salesforce Emily youtube channel here.
You can read more about us here
And check out our courses here