Configure the formula builder

configure-formula-builder-irm.md
Raw file

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

  1. Navigate to All > Formula builder > Configuration.

  2. Select New.

  3. 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.

4. Select **Submit**.

Parent Topic:Formula building in a calculated metric definition

Search documentation
Search document titles and file paths on the australia branch