#### Numeric Calculations

Numeric calculations allow new numeric columns to be created.

They typically use one or more of the following operators:

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 |

And one or more of the following functions:

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.
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") |

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 |