1. Calculation functions
  2. All functions
  3. Aggregation functions

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 Description
ALL

The ALL aggregation function returns a TRUE result for all values that match specific Boolean criteria in a source module.

ANY

The ANY aggregation function returns a TRUE result for any value that matches specific Boolean criteria in a source module.

AVERAGE

The AVERAGE aggregation function takes a set of values from a source module and returns the mean average in a result module.

FIRSTNONBLANK

The aggregation function FIRSTNONBLANK returns the first value of a line item found for a given list item or time period. 

LASTNONBLANK

The aggregation function LASTNONBLANK returns the last value of a line item found for a given list item or time period. 

MAX

The MAX aggregation function returns the maximum value from a line item in a source module.

MIN

The MIN aggregation function returns the minimum value from a line item in a source module.

SUM

The SUM aggregation function sums values in a result module based on mapping from a source module.

TEXTLIST

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.

Disclaimer

We may update our documentation occasionally, but will only do so in a way that does not negatively affect the features and functionality of the Anaplan service.