Altair® Panopticon

# 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 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. 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. 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