Aggregation Function

This field transform function calculates an aggregated value for several numerical source fields, e.g. the sum of two columns. For this function, at least two input fields are required. A warning is raised if the input fields do not contain numerical values.

  

Parameters

Aggregate

The aggregation function. Possible values are “sum”, “count”, “min”, “max”, and “avg”.

  

Example

Sum of 2 columns. Inputs include:

LineCost1
LineCost2

Aggregate parameter is sum.

Updated March 6, 2025