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.]

TitleSyntaxDescription
ALLSource[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.

ANYSource[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.

AVERAGEValues 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.

FIRSTNONBLANKLine 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.

LASTNONBLANKLine 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.

MAXSource[MAX: Mapping, MAX: Mapping 2, etc.]

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

MINSource[MIN: Mapping, MIN: Mapping 2, etc.]

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

SUMValues 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.

TEXTLISTValues 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.

Disclaimer

We update Anapedia regularly to provide the most up-to-date instructions.