Math and trigonometric functions

This table lists the math and trigonometric functions that are not supported in TM1 Web.

Function	Description
FACTDOUBLE	Returns the double factorial of a number.
GCD	Returns the greatest common divisor.
LCM	Returns the least common multiple.
MDETERM	Returns the matrix determinant of an array.
MINVERSE	Returns the matrix inverse of an array.
MMULT	Returns the matrix product of two arrays.
MROUND	Returns a number rounded to the desired multiple.
MULTINOMIAL	Returns the multinomial of a set of numbers.
QUOTIENT	Returns the integer portion of a division.
RANDBETWEEN	Returns a random number between the numbers you specify.
SERIESSUM	Returns the sum of a power series based on the formula.
SQRTPI	Returns the square root of (number * pi).
SUBTOTAL	Returns a subtotal in a list or database.
SUMIFS	Adds all of the arguments that meet multiple criteria.
SUMPRODUCT	Returns the sum of the products of corresponding array components.
SUMSQ	Returns the sum of the squares of the arguments.
SUMX2MY2	Returns the sum of the difference of squares of corresponding values in two arrays.
SUMX2PY2	Returns the sum of the sum of squares of corresponding values in two arrays.
SUMXMY2	Returns the sum of squares of differences of corresponding values in two arrays.
TRUNC	Truncates a number to an integer.