Add a Row-Level Formula in Report #inSalesforce

on

This adds a row-level formula column to your report that makes calculations on every report row.


Steps:

Go to the Report | Create new report or edit an existing one | From the Columns section of the Outline pane | click the more actions icon | Add Row-Level Formula | Here enter a Column Name, choose a Formula Output Type, and write a Formula as per need. | Click Validate. Click Apply | The row-level formula appears as a column on the report | Save and Run


Example:

Suppose you have created a Oppty and we want add a row level formula named "Time to Close" (formula output - number). Here formula = CLOSE_DATE - DATEVALUE(CREATED_DATE). Please check visual for details


Visual: https://www.youtube.com/watch?v=BdxxX-UvcoM


Reference: https://help.salesforce.com/s/articleView?id=sf.reports_formulas_row_level_add.htm&type=5

Comments

Post a Comment