In a calculated metric definition, you can create formulas to perform calculations for any data that you may require.

A formula consists of operands, operators, and functions. For example, if you want to calculate the total employee count from two metric definitions namely number of male employees and number of female employees, then the selected metric definitions are the operands and the operator is the symbol or function that performs a specific operation on the operands to obtain a result. Examples of operators include addition (+), subtraction (-), multiplication (*), and division (/).

You can set default values for operands in the Calculated Metric Definition Settings table to ensure metric calculations continue smoothly even when data is missing or undefined. When a formula encounters an empty operand, the system automatically applies the configured default value from this table, allowing the calculation to proceed without interruption. Users can activate the shipped default record or create custom entries with preferred values for specific operands. This setup enhances the reliability and flexibility of metric logic, reduces manual intervention, and supports consistent results across varying data conditions.