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) |
Thank you for your feedback and comments.We will rectify this as soon as possible!