Filter
Top Products
Lists 459
Reverse Creates a list by reversing the order of the elements in a
list.
REVERSE(list)
Example:
REVERSE({1,2,3}) returns {3,2,1}
Concatenate Concatenates two lists into a new list.
CONCAT(list1,list2)
Example:
CONCAT({1,2,3},{4}) returns {1,2,3,4}.
Position Returns the position of an element within a list. The
element can be a value, a variable, or an expression. If
there is more than one instance of the element, the
position of the first occurrence is returned. A value of 0 is
returned if there is no occurrence of the specified element.
POS(list, element)
Example:
POS ({3,7,12,19},12) returns 3
Size Returns the number of elements in a list.
SIZE(list)
Example:
SIZE({1,2,3}) returns 3