Evaluate Each Record in Reports with Row-Level Formulas | Evaluate Report Data with Formulas

Описание к видео Evaluate Each Record in Reports with Row-Level Formulas | Evaluate Report Data with Formulas

FORMULA SUPERBADGE UNIT
100 POINTS~
-------------------------------------------------
Evaluate Report Data with Formulas

See Record Level Results with Row-Level Formulas
Let’s show Gabriela how to add a row-level formula to an opportunity report. We’ll set up a row-level formula that calculates the number of days each opportunity takes to close.

Create an opportunity report.
From the Columns section of the Outline pane, click Down arrow | Add Row-Level Formula.
From the Edit Row-Level Formula Column window, create the formula:
In Column Name, enter Time to Close.
In Description, enter Time to Close in Days.
From Formula Output Type, select Number. Even though this formula works with date values, number is the output type needed because the formula performs subtraction and returns a number.
Set Decimal Points to 0.
In Formula, write:
CLOSE_DATE - DATEVALUE(CREATED_DATE)
CLOSE_DATE and CREATED_DATE are the API names of the Close Date and Created Date fields. Formulas work with the API names of fields, not the display names. The easiest way to enter the API name of a field is to search for it from the FIELDS menu, select it, and click Insert .
Because CLOSE_DATE's data type is date and CREATED_DATE's data type is datetime, we convert the value of CREATED_DATE to the date data type with the DATEVALUE() function. The two values must have a matching data type so that we can subtract one from the other. (Datetime and date are different data types because datetime includes information about units of time smaller than a day - hours, minutes, seconds, and so on - and DATE does not.)
To make sure that the formula is error-free, click Validate. If necessary, resolve errors.
Click Apply.
Click Save & Run.
Name the report Opportunity with Formula.
Click Save.
That’s all there is to it! Now when Gabriela views the Opportunity report, she can scan the Time to Close column (the rightmost column) to see the number of days that each opportunity took to close.

Комментарии

Информация по комментариям в разработке