Calculated Field

Type: CALCULATED

A computed field that automatically evaluates a formula based on other field values.

Properties

• Dimensions: Supports scalar result

• Required: Can be set conditionally based on expressions

• Formula: Mathematical expression referencing other fields

Formula Syntax

Formulas support:

Operators

• + Addition

• - Subtraction

• * Multiplication

• / Division

• - Unary minus (negative numbers)

Functions

• SUM(fieldName) - Sum all values in an array field

Field References

Reference other fields by their field name directly in the formula.

Examples

price * quantity
total - discount
(subtotal * 0.1) + delivery_fee
SUM(line_items) * tax_rate

Validation

• Only arithmetic operators (+, -, *, /) allowed

• Only SUM() function supported

• SUM() requires exactly one argument (field name)

• SUM() can only be used with array fields (dimensions > 1)

• Referenced fields must exist in the process

• Division by zero returns error

Use Cases

• Price calculations

• Totals and subtotals

• Tax and discount computation

• Derived metrics

• Aggregations from array fields

• Formula-based business logic