Scalar FunctionsSeries Functions

series_max

Returns the maximum value in a numeric series, ignoring null values.

Syntax

series_max(series)

Prop

Type

Returns: real

print series_max(dynamic([500, 7000, 1200, 300, 4000]))

print_0 (real)
7000.0

series_log

Calculates the natural logarithm of each element. Returns NaN for non-positive values.

series_min

Returns the minimum value in a numeric series, ignoring null values.