Developer Transformation Guide

10.5
- 10.5.2
- 10.4.1
- 10.4.0

Back Next

CONSOL_AVG

Analyzes a port in the record group and returns the average of all values.

Syntax

CONSOL_AVG(string, group by)

The following table describes the arguments for this command:

Argument	Required/Optional	Description
string	Required	Input port name.
group by	Required	Name of the input port that contains the group identifier.

Return Value

The average of all values in a port.

For String and Date/time datatypes, the function returns the most frequently occuring value.

Example

The following expression uses the

CONSOL_AVG

function to find the average value of the SalesTotal input port:

SalesTotal1:= CONSOL_AVG(SalesTotal, GroupKey)

In this expression, the

CONSOL_AVG

function uses the GroupKey port to identify a record group. Within that record group, the function analyzes the SalesTotal port and returns the average value. The expression writes the average value to the SalesTotal1 output port.

Rename Saved Search

Table of Contents

Developer Transformation Guide

Developer Transformation Guide

CONSOL_AVG

CONSOL_AVG

Syntax

Return Value

Example