Scalar FunctionsSeries Functions

series_avg

Returns the average (mean) of all elements in a numeric series, ignoring null values.

Syntax

series_avg(series)

Prop

Type

Returns: real

print series_avg(dynamic([48, 72, 36, 55, 60]))

print_0 (real)
54.2

series_add

Element-wise addition of two numeric series.

series_ceiling

Rounds each element up to the nearest integer.