Filter
Top Products
Lists 461
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
LIST Creates a new list composed of the first differences of a
list; that is, the differences between consecutive elements
in the list. The new list has one less element than the
original list. The differences for {x
1
, x
2
, x
3
,... x
n-1
, x
n
} are
{x
2
–x
1
, x
3
–x
2
,... x
n
–x
n–1
}.
LIST(list1)