Metric definition setting record fields

  • Release version: Xanadu
  • Updated October 24, 2025
  • 1 minute to read
  • The fields of the metric definition setting record form are explained in this topic.

    Table 1. Metric definition setting record
    Field Description
    Name Name for the record. For example, Default record for CMD calculations.
    Active Option to mark the default values record as active.
    One for null record You can select relevant operators in the field. If a metric operand is null or undefined during formula execution, and the adjacent operator matches the one selected, the system assigns a default value of 1 to that operand—ensuring the calculation proceeds without error.
    Order Determines the priority of the record when multiple records are available. The record which has the highest number is selected
    Skip null record You can select relevant operators in the field. If a metric operand is null or undefined during formula execution and the adjacent operator matches the one selected, the system will skip that operand from the calculation. This prevents errors and ensures the formula continues without interruption.
    Zero for null record You can select relevant operators in the field.If a metric operand is null or undefined during formula execution and the adjacent operator matches the one selected in this field, the system assigns a value of 0 to that operand. This ensures the calculation proceeds without error and maintains consistency in results.
    Type Displays the type of metric definition. This field is automatically set to Calculated metric definition.
    Table name Specifies the name of the table where the default values are stored. This field is auto-populated.
    Filter Specifies the condition under which the default values defined in this record should be applied during CMD formula execution. You can setup multiple criteria conditions.