Configure the formula builder
Specify the formula context, the tables, and the identifiers before you can build a formula.
Before you begin
Role required: admin
About this task
It’s necessary to configure the formula builder before a formula can be built in a calculated metric definition. During configuring, you can specify the formula context, the tables to use, and their conditions.
Procedure
Navigate to All > Formula builder > Configuration.
Select New.
On the form, fill in the fields.
| Field | Description |
|---|---|
| Formula context | Configuration available to create the formula for a specific option. The choices for Risk are as follows:- Calculation level - entity (Risk) - Calculation level - metric definition (Risk) Note: Users of other applications can select different context options. |
| Application | Scope of the application. This field is automatically set. |
| Table | Tables that you want to use while building the formula. |
| Condition | Criteria using which the records are filtered from the selected table when building the formula. For example, you can build a condition that Domain is Risk. |
| Display field | Unique display name for the operands such as the Name field or the ID field. |
| Identifier | An abbreviated two-letter combination of lowercase letters that is associated with a specific table name. For example, if your table name is Hardware accessories, your identifier can be ha.Note: Using fn as an identifier isn’t permitted as fn refers to function. |
| Show additional columns | Option to decide if you want additional columns to be displayed.Note: This option is useful in cases where there are duplicate emission factor names. Showing additional details can help metric managers to select the right emission factor. |
| Primary column | Primary column that you 'd like displayed.Note: This field appears only when the Show additional columns option is selected. |
| Secondary column | Secondary column that you'd like displayed.Note: This field appears only when the Show additional columns option is selected. |
| Primary column label | Preferred label of the primary column selected.Note: This field appears only when the Show additional columns option is selected. |
| Secondary column label | Preferred label of the secondary column selected.Note: This field appears only when the Show additional columns option is selected. |
- Select Submit.
Parent Topic:Formula building in a calculated metric definition