◷ Reading Time: 10 minutes
all 
Returns false if any item is false, else true if empty or all items are true, else null.
all (list)- list (array): list of Boolean items or an argument list of one or more Boolean items (Mandatory)
Example: all(true, true, true)
Result: true
Example: all(true, false, true, true)
Result: false
any
Returns true if any item is true, else false if empty or all items are false, else null.
any (list)- list (array): list of Boolean items or an argument list of one or more Boolean items (Mandatory)
Example: any(null, true, 0, false)
Result: true
Example: any([])
Result: false
append
Returns new list with items appended.
append (list, item)- list (array): list of elements including null (Mandatory)
- item (any element including null): item or items to be appended to list (Mandatory)
Example: append([1, 2], 3)
Result: [1, 2, 3]
Example: append([1], 2, 3)
Result: [1, 2, 3]
concatenate
Returns new list that is a concatenation of the arguments.
concatenate (list)- list (any elements including null): list of elements to be concatenated (Mandatory)
Example: concatenate([1, 2, 3], [4, 5, 6],[7, 8])
Result: [1, 2, 3, 4, 5, 6, 7, 8]
Example: concatenate([1],[3, 4],[5, 6])
Result: [1,3,4,5,6]
count
Returns the size of a list– if the list is empty zero is returned.
count (list)- list (array): given list to return the size count from (Mandatory)
Example: count(2, 3)
Result: 2
Example: count(1, 2, 3)
Result: 3
distinct values
Removes duplicates from a list.
distinct values (list)- list (array): given list to return distinct values from (Mandatory)
Example: distinct values(1, 1, 2, 3, 4, 5, 5)
Result: [1, 2, 3, 4, 5]
Example: distinct values(1, 2, 3, 2, 1)
Result:[1, 2, 3]
flatten
Returns a flattened non-nested list from the given list.
flatten (list)- list (array): non-empty list of numbers or argument list of numbers (Mandatory)
Example: flatten([[1 ,2],[[3]], 4])
Result: [1, 2, 3, 4]
Example: flatten([[1 ,2],[[3],[["Cat", "Dog"],[1]]], 4])
Result: [1, 2, 3, “Cat”, “Dog”, 1, 4]
insert before
Returns a new list with newItem inserted into position. If position is greater than length or zero newItem will be inserted at the end of the list. If position is negative and its absolute value is greater than length it newItem will be inserted at the beginning of the list.
insert before (list,position,newItem)- List (array): list of elements including null (Mandatory)
- Position (non-zero integer): represents a position within range of the list (1 is the first position in the list and -1 is the last) (Mandatory)
- newItem (any element including null): item to be inserted at the given position
Example: insert before([1, 3], 1, 2)
Result: [2, 1, 3]
Example: insert before([1, 2, 3], -1, "new")
Result: [1, 2, "new", 3]
list contains
Returns true if the list contains the given element, otherwise returns false.
list contains (list, element)- list (array): list of elements including null (Mandatory)
- element (any element including null): element to check (Mandatory)
Example: list contains([1,2,3], 2)
Result: true
Example: list contains([7, 8, 9, [10]], [10])
Result: true
list replace
Return a new list with newItem replaced at specified position.
list replace ( list, position, newItem)- list (array): list of elements including null (Mandatory)
- position: position index(Mandatory)
- newItem: any element including null(Mandatory)
Example: list replace( [2, 4, 7, 8], 3, 6)
Result: [2, 4, 6, 8]
Example: list replace(["James","Daniel","Jone"],-1,"Karl")
Result: ["James","Daniel","Karl"]
mean
Returns arithmetic mean (average) of given numbers.
mean (list)- list (array): non-empty list of numbers or argument list of one or more numbers (Mandatory)
Example: mean(1, 2, 3)
Result: 2
Example: mean([-1, 0, 1])
Result: 0
product
Returns product of given numbers or null if list is empty
product (list)- list (array): list of 0 or more numbers or an argument list of one or more numbers (Mandatory)
Example: product(1,2)
Result: 2
sublist
Returns a list based on given starting position and length for the provided list. If no length is provided the entire list after the starting position will be returned.
sublist (list, start position, length)- list (array): a list to return the sublist from (Mandatory)
- start position (non-zero integer): position to start from in the list (1 is the first position of the list and -1 is the last position) (Mandatory)
- length (non-negative integer): length from the starting position to return (1 returns 1 value and 0 will return an empty list) (Optional)
Example: sublist([1, 2, 3, 4, 5], 2, 2)
Result:[2, 3]
Example: sublist([1, 2, 3, 4, 5], -2, 1)
Result: [4]
sum
Returns sum of given numbers or null if list is empty
sum (list)- list (array): list of 0 or more numbers or an argument list of one or more numbers (Mandatory)
Example: sum(4, 5, 6) Result: 15
Example: sum(1, 2, 3)
Result: 6
Example: sum(2, 3, 4)
Result: 24
remove
Removes item at given position in a list.
remove (list)- List (array): list of elements including null (Mandatory)
- Position (non-zero integer): represents a position within range of the list (1 is the first position in the list and -1 is the last) (Mandatory)
Example: remove ([1 ,2,3], 2)
Result: [1, 3]
Example: remove([1, 2, 3], -1)
Result: [1, 2]
reverse
Reverses the given list.
reverse (list)- list (array): list of elements including null (Mandatory)
Example: reverse([1, 2, 3])
Result: [3,2,1]
stddev
Returns the sample standard deviation of the list of numbers. If the list is empty or if the list contains only one element, the function returns null.
stddev (list)- list (array): non-empty list of numbers or argument list of numbers (Mandatory)
Example: stddev([1, 3, 5, 7, 9])
Result: 3.1622776601683795
Example: stddev(2, 4, 6)
Result: 2
mode
Returns the mode of the list of numbers. If the result contains multiple elements, they are returned in ascending order. If the list is empty, an empty list is returned.
mode (list)- list (array): non-empty list of numbers or argument list of numbers (Mandatory)
Example: mode( 6, 3, 9, 6, 6 )
Result: [6]
Example: mode( [6, 1, 9, 6, 1] )
Result: [1, 6]
union
Returns the union (concatenate with duplicate removal) of given lists.
union (list)- list (array): non-empty argument list or lists. Must be as an array. (Mandatory)
Example: union([1,2],[2,3])
Result: [1, 2, 3]
Example: union([1,2],[1,2,3],[1,2,3,4])
Result: [1, 2, 3, 4]
index of
Return ascending list of list positions containing match.
index of (list, element)- list (array): non-empty list of numbers or argument list of numbers (Mandatory)
- element(number): a number to lookup index (Mandatory)
Example: index of([1, 2, 3, 4], 3)
Result: [3]
Example: index of([1, 2, 3, 4], 5)
Result: []
median
Returns the median element of the list of numbers. After sorting the list, if the list has an odd number of elements, it returns the middle element. If the list has an even number of elements, returns the average of the two middle elements.
median (list)- list (array): list (array): non-empty list of numbers or argument list of numbers (Mandatory)
Example: median( 8, 2, 5, 3, 4 )
Result: 4
Example: median( [6, 1, 2, 3] )
Result: 2.5
min/max
Returns the minimum(maximum) item.
min (list) max (list)- list (array): non-empty list of numbers or argument list of numbers (Mandatory)
Example: min([1,2,3])
Result: 1
Example: max(1,2,3)
Result: 3