[]
You could use PI
and E
identifiers for arguments of Math functions or in other expressions.
Returns the absolute value of a specified number.
Syntax
Abs(number
)
Arguments
number
- a number for which you want to return the absolute valueExamples
You can use the following expression to return the absolute value of the difference between the NetSales
and ProjectedSales
fields.
{Abs(NetSales - ProjectedSales)}
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 cosineExamples
You can use the following expression to return the angle whose cosine is -0.5
{Acos(-0.5)}
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 sineExamples
You can use the following expression to return the angle whose sine is 0.77
{Asin(0.77)}
Returns the angle in radians whose tangent is the specified number.
Syntax
Atan(number
)
Arguments
number
- a number between representing a tangentExamples
You can use the following expression to return the angle whose tangent is -0.234
{Atan(-0.234)}
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)}
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)}
Returns the smallest integral value greater than or equal to the specified number.
Syntax
Ceiling(number
)
Arguments
number
- a number to return the "ceiling" forExamples
You can use the following expression to return the "ceiling" of 5.789
{Ceiling(5.789)}
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)}
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)}
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)}
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)}
Returns the smallest integral value less than or equal to the specified number.
Syntax
Floor(number
)
Arguments
number
- a number to return the "floor" forExamples
You can use the following expression to return the "floor" of 15.789
{Floor(15.789)}
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)}
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)}
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)}
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)}
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 roundExamples
You can use the following expression to return the rounding result of PI
{Round(PI)}
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 signExamples
You can use the following expression to return the sign of -234
{Sign(-234)}
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)}
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)}
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)}
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)}
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)}
Calculates an integral part of a number.
Syntax
Truncate(number
)
Arguments
number
- a number to truncateExamples
You can use the following expression to truncate 123.564
{Truncate(123.654)}
Submit and view feedback for