To work with the tool in Foresight Analytics Platform 10, use the new interface.

Mathematical Functions

When working with formulas, the user can use predefined math functions listed in the table below:

Function	Brief description
Abs	It returns the module (absolute value) of a number.
ACos	It returns the number arccosine.
ACosH	It returns hyperbolic arccosine of a number.
ACot	It returns the arccotangent of the number.
ACotH	It returns the hyperbolic arccotangent of the number.
Aggregate	It returns result of aggregation with selected method with a possibility to not taking into account hidden values on calculation.
ASin	It returns the number arcsine.
ASinH	It returns the hyperbolic arcsine of a number.
ATan	It returns the number arctangent.
ATan2	It returns the arctangent for the specified X and Y coordinates.
ATanH	It returns the hyperbolic arctangent of the number.
Average	It returns the average of an array of cells.
AverageIf	It returns the average of cells that satisfy the specified condition.
AverageIfS	It returns the average of cells that satisfy the specified set of conditions.
Ceiling	It returns the result of rounding the value up, to the nearest integer or to the nearest multiple of significance.
Combin	It returns the number of combinations for the specified number of objects.
Cos	It returns the cosine of the specified angle.
CosH	It returns the hyperbolic cosine of a number.
Cot	It returns the cotangent of an angle.
CotH	It returns the hyperbolic cotangent of a number.
Count	It returns the number of elements in an array of cells.
CountIf	It returns the number of cells that satisfy the specified condition.
CountIfS	It returns the number of cells that satisfy the specified set of conditions.
Degrees	It returns a value converted from radians to degrees.
Even	It returns the result of rounding the value to the nearest even integer.
Exp	It returns the result of raising the number "e" to the specified power.
Fact	It returns the factorial of the specified number.
Floor	It returns the result of rounding the number to the nearest integer smaller in modulus.
Gcd	It returns the greatest common divisor for two or more integers.
Int	It returns the result of rounding the value to the nearest smaller integer.
Lcm	It returns the least common multiple for two or more integers.
Ln	It returns the natural logarithm of a number.
Log	It returns the number logarithm based on the specified base.
Log10	It returns the base-10 logarithm of the specified number.
Max	It returns the maximum number in the cell array.
MDeterm	It returns the matrix determinant of a cell array.
Min	It returns the minimum number in the cell array.
MInverse	It returns an inverse matrix for the specified matrix.
MMult	It returns the number matrix equal to the product of the two matrixes.
Mod_	It returns the remainder from dividing a number by a denominator.
MRound	It returns a number rounded with desired precision.
Multinomial	It returns the multinomial of a set of numbers, for which you want the multinomial.
Odd	It returns the result of rounding the value to the nearest odd integer.
Power	It returns the result of raising a real number to real power.
Product	It returns the product of cell array values.
Quotient	It returns the integer part of the result of division with a remainder.
Radians	It returns a value converted from degrees to radians.
Rand	It returns a random number greater than or equal to 0 and less than 1, evenly distributed.
RandBetween	It returns a random number between two specified numbers.
RndPermutation	It returns an array that is an arbitrary permutation of another array, which elements are integers ranging from 1 to the value of the passed parameter.
RndSample	It returns the random sample of M elements from the elements array, which are integers from 1 to N.
Roman	It returns the result of converting an Arabic number into a Roman as text.
Round	It returns the result of rounding a number to the specified number of decimal places.
RoundDown	It returns the result of rounding the number to the nearest value smaller in modulus.
RoundUp	It returns the result of rounding the number to a nearest value greater in modulus.
SeriesSum	It returns the sum of a power series.
Sign	It returns the number sign.
Sin	It returns the sine of the specified angle.
SinH	It returns hyperbolic sine of the specified number.
Sqrt	It returns positive value of a square root.
SqrtPi	It returns the square root from the expression value: Number * Pi.
Sum	It returns the sum of real numbers from the specified cell range.
Sumif	It returns the sum of numbers in the specified cell range that satisfy the specified condition.
SumIfS	It returns the sum of numbers in the specified cell range that satisfy the specified set of conditions.
SumSq	It returns the sum of squares of numbers from the specified cell range.
SumX2MY2	It returns the sum of differences of squares of corresponding values in two arrays.
SumX2PY2	It returns the sum of sums of squares of corresponding values in two arrays.
SumXMY2	It returns the sum of squares of the differences of corresponding values in two arrays.
Tan	It returns the tangent of the specified angle.
TanH	It returns the hyperbolic tangent of the specified angle.
Trunc	Truncates a number to the specified number of decimal places.