Operator

Name

Description

!

Logical NOT

Logical NOT.

%

Integer Division

Integer Division

&

Logical AND

Logical AND.

*

Multiply

Multiplies two numbers.

+

Add

Adds two numbers.

-

Subtract

Subtracts two numbers.

/

Divide

Divides two numbers.

<=

Less than or equals

Less than or equals to.

<> 

Not Equals

Not Equals.

=

Equals

Equals.

>=

Greater than or equals

Greater than or equals to.

^

Raises to the power

Raises number to the power of number2, number1 ^ number2.

|

Logical OR

Logical OR

Function

Description

ABS

Absolute value, which can be used as ABS(X).

ATAN

ArcTangent function which can be used as ATAN(X).

CEIL

Ceiling function.

Examples: CEIL(-3.2) = -3, CEIL(3.2) = 4.

COS

Cosine function which can be used as COS(X), where X is a real-type expression. COS returns the cosine of the angle X in radians.

COSH

Cosine Hyperbolic function which can be used as COSH(X).

COTAN

Cotangent function which can be used as COTAN(X).

EXP

Exponential function which can be used as EXP(X).

FLOOR

Floor function.

Examples: FLOOR(-3.2) = -4, FLOOR(3.2) = 3.

HEX2DEC

Converts a hexadecimal number to decimal.

Example: HEX2DEC("FF") = 255

IF

Conditional Statement

The IF(b, case1, case2) function provides branching capability.

·         If b is True, then it returns case 1.

·         If b is False, then it returns case 2.

·         If b is a numeric value 1, it is equal to True.

·         If b is a numeric value 0, it is equal to False.

NOTE: By default, the function returns a value of data type Text. To force the data type to numeric, you can either use “Set type manually” or do a calculation with a numeric value, such as multiply by 1.

Examples:

IF([Actual] >= [Budget], “Good job”, “Not done”)

IF([Some_Number] = 0, 0, 1/[Some_Number])*1

INTPOW

Raises Base to an integral power.

Example: INTPOW(2, 3) = 8. Note that the result of INTPOW(2,3.4) = 8 as well.

ISNULL

If the measure Is Null or NaN, then 1 is returned, else 0 is returned.

LN

Natural Log which can be used as LN(X).

LOG

10 Based Log which can be used as LOG(X).

LOGN

The LogN function returns the log base N of X.

Example: LOGN(10, 100) = 2

MAX

Maximum of two input values.

Example: MAX(2, 3) = 3

MIN

Minimum of two input values.

Example: MIN(2, 3) = 2

MOD

Remainder of division.

Example: MOD(7, 3) = 1

POW

Raises Base to any power. For fractional exponents or exponents greater than MaxInt, Base must be greater than 0.

RANDOM

RND(X) generates a random INTEGER number such that 0 <= Result < int(X). If X is negative, then result is int(X) < Result <= 0. RANDOM(X) generates a random floating point number such that 0 <= Result < X. If X is negative, then result is X < Result <= 0.

REGEX_EXTRACT

Returns matching data from the value based on regex. Expression is REGEX_EXTRACT("value", "regex")

REGEX_EXTRACT_GROUP

Like the REGEX_EXTRACT function, apart from the third “group” parameter, which defines which group, as defined by the regex expression, to return. Group is a string parameter and can contain either an integer value or a group name.

Examples:

·        REGEX_EXTRACT_GROUP(“some123”, “([a-z]*)(\d*)”, “1”) = “some”

·        REGEX_EXTRACT_GROUP(“some123”, “([a-z]*)(\d*)”, “2”) = “123”

SIGN

SIGN(X) returns -1 if X<0; +1 if X>0, 0 if X=0; it can be used as SQR(X).

SIN

Sinus function which can be used as SIN(X), X is real-type expression. SIN returns the sine of the angle X in radians.

SINH

Sine Hyperbolic function which can be used as SINH(X).

SQR

Square function which can be used as SQR(X).

SQRT

Square Root function which can be used as SQRT(X).

TAN

Tangent function which can be used as TAN(X).

TRUNC

Discards the fractional part of a number.

Examples: TRUNC(-3.2) = -3 and TRUNC(3.2) = 3