Calculation Formulas

Back to Calculation Formulas Overview
Back to Functions Overview

Function "SetOf"

SetOf([arg1, ... , argN])

Function: Returns a set that contains all arguments. If some arguments are also sets, then the resulting set will contain all elements from these sets individually (i.e. the resulting set will not contain the other sets themselves as its elements, but rather will contain all elements from these other sets). If no argument is given at all, then an empty set is returned.

Return-Type: Number Set or Text Set, depending on the arguments (see below).

Arguments:
(All arguments are optional)
arg1 - Can be of any type, except Boolean: The first element to include in the result set.
...
argN - Can be of any type, except Boolean: The Nth (and last) element to include in the result set.
If any of the arguments is of type Text or Text Set, then the resulting set will also be a Text Set. If all arguments are either of type Number or Number Set, then the resulting set will be a Number Set. Arguments of type Boolean are not allowed.

Examples:
SetOf(3, 19882, -4, 3371)
SetOf("abc", "def", "ghi")
SetOf("abc", 15, SetOf("xyz", "qvw"), 28, "def")
SetOf(&VALUE1;, "xyz", &MULTI_SELECT_FIELD;)