Numeric Scalar Functions

Avg (numbers, break_col, break_value)

Returns the average (arithmetic mean) of values in a number column. The average includes null values when calculating the arithmetic mean.

Avg example

AvgNonNull (numbers, break_col, break_value)

Returns the average (arithmetic mean) of values in a number column, excluding null values.

AvgNonNull example

chr (n)

Returns string converted from ASCII numeric code n.

Example:

Chr (65) = A

ColMax (numbers, break_col, break_value)

Returns the largest value in a column of numbers.

ColMax example

ColMin (numbers, break_col, break_value)

Returns the smallest value in a column of number.

ColMin example

Count (numbers, break_col, break_value)

Counts and returns the number of rows in a column.

Count example

CountDistinct (numbers, break_col, break_value)

Counts and returns the number of values in a column.

CountDistinct example

CountNonNull (numbers, break_col, break_value)

Counts the number of rows in a column.

CountNonNull example

CountNull (numbers, break_col, break_value)

Counts the number of rows in a column that contains null values.

CountNull example

Cume (numbers, break_col)

Returns a cumulative running total for each value in a column of numbers.

Cume example

Next (c)

Returns the next row value of the referenced item c.

Prior (c)

Returns the prior row value of the referenced item c.

Sum (numbers, break_col, break_value)

Returns the total of a column of numbers.