Aggregation functions - Anaplan Technical Documentation

Use aggregation functions to retrieve values from source line items.

The data retrieved by aggregation functions is based on one or more mappings. Each mapping is a line item or property with the list data type. This list must also apply to the source line item. The values of the mappings determine which values to retrieve.

Each aggregation function uses a distinct syntax in the following format:

Data source[Function: Mapping 1, Function: Mapping 2, etc.]

Title	Syntax	Description
ALL	`Source[ALL: Mapping, ALL: Mapping 2, etc.]`	The ALL aggregation function returns a TRUE result for all values that match specific Boolean criteria in a source module.
ANY	`Source[ANY: Mapping, ANY: Mapping 2, etc.]`	The ANY aggregation function returns a TRUE result for any value that matches specific Boolean criteria in a source module.
AVERAGE	`Values to average[AVERAGE: Mapping, AVERAGE: Mapping 2, etc.]`	The AVERAGE aggregation function takes a set of values from a source module and returns the mean average in a result module.
FIRSTNONBLANK	`Line item to search [FIRSTNONBLANK: Mapping, FIRSTNONBLANK: Mapping 2, etc.]`	The aggregation function FIRSTNONBLANK returns the first value of a line item found for a given list item or time period.
LASTNONBLANK	`Line item to search[LASTNONBLANK: Mapping, LASTNONBLANK: Mapping 2, etc.]`	The aggregation function LASTNONBLANK returns the last value of a line item found for a given list item or time period.
MAX	`Source[MAX: Mapping, MAX: Mapping 2, etc.]`	The MAX aggregation function returns the maximum value from a line item in a source module.
MIN	`Source[MIN: Mapping, MIN: Mapping 2, etc.]`	The MIN aggregation function returns the minimum value from a line item in a source module.
SUM	`Values to sum[SUM: Mapping, SUM: Mapping 2, etc.]`	The SUM aggregation function sums values in a result module based on mapping from a source module.
TEXTLIST	`Values to list[TEXTLIST: Mapping, TEXTLIST: Mapping 2, etc.]`	The TEXTLIST aggregation function returns a collection of text values as a comma-separated value. The values returned are based on mapping from a source module.