Aggregate_Val

Purpose

Performs an aggregation function (Sum, Count, Max, Min) on a bracketed string.

Arguments

Aggregate_Val(

<expr>
// A valid rules engine expression, number, variable, or quoted string to be stored in <var>.
,<func>
// Sum, Count, Max, or Min
)

Example: String

Aggregate_Val( "[127][231][0]", "Max" )

Returns: 231

Example: Variable

If x is a variable equal to “Max”

Aggregate_Val( "[127][231][0]", x )

Returns: 231

Aggregate_Val(
<expr>	// A valid rules engine expression, number, variable, or quoted string to be stored in <var>.
,<func>	// Sum, Count, Max, or Min
)