Configure Number expression
Functions
ABS
| Syntax | ABS(numeric_expression) |
| Description | Returns the absolute value of a given expression. |
| Example | ABS([Freight]) |
ACOS
| Syntax | ACOS(numeric_expression) |
| Description | Returns the inverse cosine (also known as arccosine) of the given numeric expression. |
| Example | ACOS(0.25) |
ASIN
| Syntax | ASIN(numeric_expression) |
| Description | Returns the inverse sine (also known as arcsine) of the given numeric expression. |
| Example | ASIN(0.25) |
ATAN
| Syntax | ATAN(numeric_expression) |
| Description | Returns the inverse tangent (also known as arctangent) of the given numeric expression. |
| Example | ATAN(0.25) |
CEIL
| Syntax | CEIL(numeric_expression) |
| Description | Returns the smallest integer value that is greater than or equal to the given numeric expression. |
| Example | CEIL([Freight]) |
COS
| Syntax | COS(numeric_expression) |
| Description | Returns the cosine of the angle specified in radians in the given expression. |
| Example | COS(0.25) |
COT
| Syntax | COT(numeric_expression) |
| Description | Returns the cotangent of the angle specified in radians in the given expression. |
| Example | COT(0.25) |
DEGREES
| Syntax | DEGREES(numeric_expression) |
| Description | Returns the angle in degrees for the one specified in radians in the given numeric expression. |
| Example | DEGREES(1.5708) |
EXP
| Syntax | EXP(numeric_expression) |
| Description | Returns the exponential value of the given expression. |
| Example | EXP([UnitsInStock]) |
FLOOR
| Syntax | FLOOR(numeric_expression) |
| Description | Returns the largest integer value that is less than or equal to the given numeric expression. |
| Example | FLOOR([Freight]) |
MOD
| Syntax | MOD(numeric_expression) |
| Description | Returns the remainder of the first numeric expression divided by the second numeric expression. |
| Example | MOD(36,6) |
LOG
| Syntax | LOG(numeric_expression) |
| Description | Returns the logarithm of the given expression to the specified base. |
| Example | LOG(DEGREES(PI())) |
PI
| Syntax | PI() |
| Description | Returns the constant value of PI. |
| Example | EXP(PI()) |
POWER
| Syntax | POWER(expression1, expression2) |
| Description | Returns the value of the given expression (expression1) to the specified power (expression2). |
| Example | POWER(EXP(1), SIN(90)) |
RADIANS
| Syntax | RADIANS(numeric_expression) |
| Description | Returns the angle in radians for the one specified in degrees in the given numeric expression. |
| Example | RADIANS(90) |
ROUND
| Syntax | ROUND(numeric_expression) |
| Description | Returns a rounded value. |
| Example | ROUND([Freight]) |
SIGN
| Syntax | SIGN(numeric_expression) |
| Description | Returns a value representing the positive (+1), zero (0), or negative (-1) sign of the given numeric expression. |
| Example | SIGN([UnitsOnOrder]) |
SIN
| Syntax | SIN(numeric_expression) |
| Description | Returns the sine of the angle specified in radians in the given expression. |
| Example | SIN(0.25) |
SQRT
| Syntax | SQRT(numeric_expression) |
| Description | Returns the square root of the given numeric expression. |
| Example | SQRT([UnitsInStock]) |
TOTALPERCENTAGE
| Syntax | TOTALPERCENTAGE(numeric_expression) |
| Description | Returns the percentage value for each row from the grand total of the given column. |
| Example | TOTALPERCENTAGE([Freight]) |
TAN
| Syntax | TAN(numeric_expression) |
| Description | Returns the tangent of the given numeric expression. |
| Example | TAN(0.25) |