Configure the formula builder

  • Release version: Australia
  • Updated March 12, 2026
  • 1 minute to read

    • 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.
      Table 1. Formula builder configuration form
      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.