> Building your report / Expressions / Functions / Math functions

Math functions

Below is a list of Math functions, which can be used in expressions.

Function Description
Abs(d) Returns the absolute value of a specified number.
Acos(d) Returns the angle whose cosine is the specified number.
Asin(d) Returns the angle whose sine is the specified number.
Atan(d) Returns the angle whose tangent is the specified number.
Atan2(y, x) Returns the angle whose tangent is the quotient of two specified numbers.
BigMul(a, b) Produces the full product of two 32-bit numbers.
CDouble(i) Converts an integer to a floating-point number.
Ceiling(d) Returns the smallest integer greater than or equal to the specified number.
CInt(d) Converts a floating-point number to an integer.
Cos(d) Returns the cosine of the specified angle.
Cosh(d) Returns the hyperbolic cosine of the specified angle.
e Represents the natural logarithmic base, specified by the constant, e.
Exp(d) Returns e raised to the specified power.
Floor(d) Returns the largest integer less than or equal to the specified number.
IEEERemainder(x, y) Returns the remainder resulting from the division of a specified number by another specified number.
Log(d) Returns the logarithm of a specified number.
Log10(d) Returns the base 10 logarithm of a specified number.
Max(val1, val2) Returns the larger of two specified numbers.
Min(val1, val2) Returns the smaller of two numbers.
Pi Represents the ratio of the circumference of a circle to its diameter, specified by the constant Pi.
Pow(x, y) Returns a specified number raised to the specified power.
Round(d) Rounds a value to the nearest integer.
RoundDP(d, decimals) Rounds a value to the specified number of decimal places.
Sign(d) Returns a value indicating the sign of a number.
Sin(d) Returns the sine of the specified angle.
Sinh(d) Returns the hyperbolic sine of the specified angle.
Sqrt(d) Returns the square root of a specified number.
StringToFloat(s) Converts the string representation of a number to its floating-point equivalent.
StringToInteger(s) Converts the string representation of a number to its integer equivalent.
Tan(d) Returns the tangent of the specified angle.
Tanh(d) Returns the hyperbolic tangent of the specified angle.
Truncate(d) Calculates the integral part of a number.

Go to top