Scalar FunctionsSeries Functions

series_sum

Returns the sum of all elements in a numeric series, ignoring null values.

Syntax

series_sum(series)

Prop

Type

Returns: real

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

print_0 (real)
13000.0

series_subtract

Element-wise subtraction of two numeric series.

case

Evaluates predicates in order and returns the first matching value.