The Sales team in our Salesforce org was conducting a performance review, so I created a detailed report to calculate the “Year-to-Date Sales” for each opportunity directly in the report.
In that report, using the row-level formula, I add a row-level formula field that calculates the “Year-to-Date Sales” by checking if the “Close Date” is within the current year and summing the “Opportunity Amount” accordingly.
Here, I will explain the row-level formula in Salesforce reports. Then, we will see how to create row level formula in Salesforce report with an example and a step-by-step explanation.
Row-Level Formula in the Salesforce Report
In a Salesforce report, a row-level formula is a custom formula field (column) that we can create directly within a report to calculate values for individual rows of data.
Unlike summary formulas, which calculate totals or averages across multiple rows, a row-level formula operates independently on each record (row).
Row-level formulas can execute calculations on existing fields in the report, apply logic, and create new calculated values that appear with the other data in the report.
Thus, row-level formulas allow us to add custom metrics and calculations without having to change the base Salesforce objects or data.
Important: We can create a row-level formula only in Salesforce Lightning.
Create Row Level Formula in Salesforce Report
Using the above scenario, we will implement the following steps to understand how to use a row-level formula in the Salesforce report.
- Go to “App Launcher” -> Search “Reports” -> Click on “Reports.”
- Then click on the “New Reports” button to create a new report.
- Go to All category -> select a Report Type, search “Opportunities, “and you can search for the object you want to create a report for. -> Select Opportunities. -> Click on Start Report.