Numeric Calculations
Numeric calculations allow new numeric columns to be created.
The typically use one or more of the following operators.
Symbol 
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 
And one or more of the following functions:
Functions 
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 realtype 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. 
IF

Conditional Statement The IF(b, case1, case2) function provides branching capability.
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. 
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 realtype 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 