Math Functions
You could use PI and E identifiers for arguments of Math functions or in other expressions.
Abs
Returns the absolute value of a specified number.
Syntax
Abs(number)
Arguments
number- a number for which you want to return the absolute value
Examples
You can use the following expression to return the absolute value of the difference between the NetSales and ProjectedSales fields.
{Abs(NetSales - ProjectedSales)}
Acos
Returns the angle in radians whose cosine is the specified number.
Syntax
Acos(number)
Arguments
number- a number between -1 and 1, inclusive, representing a cosine
Examples
You can use the following expression to return the angle whose cosine is -0.5
{Acos(-0.5)}
Asin
Returns the angle in radians whose sine is the specified number.
Syntax
Asin(number)
Arguments
number- a number between -1 and 1, inclusive, representing a sine
Examples
You can use the following expression to return the angle whose sine is 0.77
{Asin(0.77)}
Atan
Returns the angle in radians whose tangent is the specified number.
Syntax
Atan(number)
Arguments
number- a number between -1 and 1, inclusive, representing a tangent
Examples
You can use the following expression to return the angle whose tangent is -0.234
{Atan(-0.234)}
Atan2
Returns the angle in radians whose tangent is the quotient of two specified numbers.
Syntax
Atan2(y, x)
Arguments
y- The y coordinate of a point.x- The x coordinate of a point.
Examples
You can use the following expression to return the angle whose tangent is the quotient of (-1,-2)
{Atan2(-1, -2)}
BigMul
Produces the full product of two 32-bit numbers.
Syntax
BigMul(a, b)
Arguments
a- The first number to multiply.b- The second number to multiply.
Examples
You can use the following expression to return the full product of the UnitPrice and Quantity fields.
{BigMul(UnitPrice, Quantity)}
Ceiling
Returns the smallest integral value greater than or equal to the specified number.
Syntax
Ceiling(number)
Arguments
number- a number to return the "ceiling" for
Examples
You can use the following expression to return the "ceiling" of 5.789
{Ceiling(5.789)}
Cos
Returns the cosine of the specified angle.
Syntax
Cos(angle)
Arguments
angle- an angle in radians.
Examples
You can use the following expression to return the cosine of the PI/2 angle.
{Cos(PI / 2)}
Cosh
Returns the hyperbolic cosine of the specified angle.
Syntax
Cosh(angle)
Arguments
angle- an angle in radians.
Examples
You can use the following expression to return the hyperbolic cosine of PI angle.
{Cosh(PI)}
Exp
Returns e(Euler's number) raised to the specified power.
Syntax
Exp(number)
Arguments
number- a number specifying a power.
Examples
You can use the following expression to return e raised to five.
{Exp(5)}
Fix
Removes the fractional part of a number and returns the resulting integer value.
Syntax
Fix(number)
Arguments
number- a number for which you want to return the integer portion.
Examples
You can use the following expression to return the integer portion of 101.789
{Fix(101.789)}
Floor
Returns the smallest integral value less than or equal to the specified number.
Syntax
Floor(number)
Arguments
number- a number to return the "floor" for
Examples
You can use the following expression to return the "floor" of 15.789
{Floor(15.789)}
IEEERemainder
Returns the remainder resulting from the division of a specified number by another specified number.
Syntax
IEEERemainder(a, b)
Arguments
a- a dividend.b- a divisor.
Examples
You can use the following expression to return the remainder from the 100/89 division.
{IEEERemainder(100, 89)}
Log
Returns the logarithm of the specified number.
Syntax
Log(number)
Arguments
number- a number for which you want to return the logarithm.
Examples
You can use the following expression to return the logarithm of 78
{Log(78)}
Log10
Returns the base 10 logarithm of the specified number.
Syntax
Log10(number)
Arguments
number- a number for which you want to return the base 10 logarithm.
Examples
You can use the following expression to return the base 10 logarithm of 1000
{Log10(1000)}
Pow
Returns a specified number raised to the specified power.
Syntax
Pow(x, y)
Arguments
x- a number to be raised to a power.y- a number that specifies a power.
Examples
You can use the following expression to return the result of 10 raised to 5
{Pow(10, 5)}
Round
Rounds a decimal number to the nearest integral value and rounds midpoint values to the nearest even number.
Syntax
Round(number)
Arguments
number- a number which you want to round
Examples
You can use the following expression to return the rounding result of PI
{Round(PI)}
Sign
Returns an integer that indicates the sign of a number
-1means a number is less than zero.0means a number is equal to zero.1means a number is greater than zero.
Syntax
Sign(number)
Arguments
number- a number for which you want to return the sign
Examples
You can use the following expression to return the sign of -234
{Sign(-234)}
Sin
Returns the sine of the specified angle.
Syntax
Sin(angle)
Arguments
angle- an angle in radians.
Examples
You can use the following expression to return the sine of the PI/4 angle.
{Sin(PI / 4)}
Sinh
Returns the hyperbolic sine of the specified angle.
Syntax
Sinh(angle)
Arguments
angle- an angle in radians.
Examples
You can use the following expression to return the hyperbolic sine of the PI angle.
{Sinh(PI)}
Sqrt
Returns the square root of a specified number.
Syntax
Sqrt(number)
Arguments
number- a number for which you want to return the square root.
Examples
You can use the following expression to return the square root sine of 144
{Sqrt(144)}
Tan
Returns the tangent of the specified angle.
Syntax
Tan(angle)
Arguments
angle- an angle in radians.
Examples
You can use the following expression to return the tangent of the PI/4 angle.
{Tan(PI / 4)}
Tanh
Returns the hyperbolic tangent of the specified angle.
Syntax
Tanh(angle)
Arguments
angle- an angle in radians.
Examples
You can use the following expression to return the hyperbolic tangent of the PI/3 angle.
{Tanh(PI / 3)}
Truncate
Calculates an integral part of a number.
Syntax
Truncate(number)
Arguments
number- a number to truncate
Examples
You can use the following expression to truncate 123.564
{Truncate(123.654)}