Skip to main content

Mathematical functions

Index of mathematical functions

abs	Returns a number's absolute value.
absDiff	Returns the absolute difference between two numbers.
averageVal	Returns the average value for a set of numbers. Deprecated — use mean.
count	Counts how many times a given value appears in the input data.
diff	Returns the difference between two numbers.
direction	Returns the change direction for a series of numbers.
div	Divides one number by another.
getRandomInteger	Returns a randomly selected integer.
getRandomNumber	Returns a randomly selected decimal number.
groupByTable	Groups table rows with matching values in one or more columns. For each group, the function aggregates the data for one or more columns.
maxVal	Returns the maximum value in a set of numbers.
mean	Returns the mean for a set of numbers.
median	Returns the median for a set of numbers.
minVal	Returns the minimum value in a set of numbers.
mode	Returns the mode for a set of numbers.
percentage	Calculates a percentage value — (base/whole) * 100.
percentageChange	Calculates the percentage change between two numbers.
percentageChangeAcrossSeries	Calculates the percentage change across a series of numbers.
power	Returns the result of a number raised to a power.
product	Returns the result of multiplying two or more numbers.
rank	Returns the rank of a value in a set of numbers.
root	Returns the nth root of a number.
round	Rounds a number to a specific number of decimal places.
sign	Returns the sign of a number (1 if positive, -1 if negative, and 0 if zero).
sum	Sums the input values (numbers or lists).
toReachThreshold	Counts the summed values required to reach a target threshold.
totalVal	Returns the total value for a set of numbers.
truncate	Truncates a number to its integer part.