v2.1.0
v2.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 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)}
``````