Aggregation functions




uAvg

Description

Calculates and returns the average value of all input values.

Syntax

real uAvg(value, ...);

Parameters

numeric value

A list of numeric arguments to calculate the average value over.

Examples

Example 1

To calculate the average value:

uAvg(1,2,3,4,5) // returns 3



uMax

Description

Returns the highest value from a set of values. This function compares the values depending on their datatype.

Syntax

uMax(value, ...)

Parameters

numeric value

A list of numeric arguments.

Examples

Example 1

To find the highest value from a set of values:

uMax(1, 6, 4, -6) // returns 6
uMax("b", "A", "a") // returns "b"
uMax("2004-05_02", "2006-12-12", "1999-05-30") // returns "2006-12-12"



uMin

Description

Returns the lowest value from a set of values.

Syntax

uMin(value, ...)

Parameters

numeric value

A list of numeric arguments.

Examples

Example 1

To find the highest value from a set of values:

uMin(1, 6, 4, -6) // returns -6
uMin("b", "A", "a") // returns "A"
uMin("2004-05_02", "2006-12-12", "1999-05-30") // returns "1999-05-30"