v2.2.0
v2.2.0v2.1.0v2.0.0v1.2.0

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

  • -1 means a number is less than zero.
  • 0 means a number is equal to zero.
  • 1 means 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)}