You are here: Processor Library > Matching > Output Selectors > Average

Output selector: Average

The Average output selector calculates and outputs the average of all Number values input to it from all the records being merged together.

Use

The Average selector is often used for reporting on data, where records are grouped together by a common attribute value (or attribute values), or matched together using complex rules.

For example, you might use Group and Merge to group a number of order records by product identifier, and calculate and output the average order value for orders for each product.

Inputs

Any Number attributes from any input data sets.

Options

Option

Type

Purpose

Default Value

Consider Nulls as 0?

Yes/No

Drives whether to consider Null values in the Number attribute as 0 values in the Average calculation, or whether to disregard them.

Yes, means Null values are treated as 0.

No, means Null values are disregarded.

Example

In this example, the Average output selector is used to select the Average for an OrderValue (Number) attribute from each record.

Example configuration

Consider nulls as zero? = No

Example output

The following table illustrates some examples of output selection using the Average selector:

Record A	Record B	Output value (Average)
1089.78	598.65	844.215
176.99	168.34	172.665
63.99	32.99	48.49
543.99	543.99	543.99
null	5	5
null	null	null