The Evaluate step evaluates mathematical expressions against input data and writes computed results to output fields. Expressions support arithmetic, comparisons, and built-in functions including array aggregations (mean, sum, min, max, stddev, first, last, firstNonZero, lastNonZero) and scalar math (abs, sqrt, ln, pow, round, cagr). Both input and output field sets are fully customizable.

• Compute financial metrics like ROE, CAGR, or margins from raw data
• Aggregate array data using functions like mean, sum, min, max, or stddev
• Transform or normalize numeric fields before passing them downstream
• Add scoring or ranking logic based on numeric criteria

Each calculation is an expression string paired with an output field name. Expressions can reference input field names directly. Scalar fields resolve to numbers and array fields resolve to number arrays. Supported operators include arithmetic (+, -, *, /, %), comparison (==, !=, >, <, >=, <=), and grouping with parentheses. Built-in functions include array aggregations (mean, sum, min, max, stddev, count, first, last, firstNonZero, lastNonZero) and scalar math (abs, sqrt, ln, pow, round, cagr). Division by zero returns 0. Comparison operators return 1.0 for true and 0.0 for false.