eMDT Help

| System
| Content Admin
| Form Editor

Calculations
Predefined functions that take one parameter are: SQR: Square function which can be used as SQR(X) SIN: Sinus function which can be used as SIN(X), X is a real-type expression. Sin returns the sine of the angle X in radians. COS: Cosinus function which can be used as COS(X), X is a real-type expression. COS returns the cosine of the angle X in radians. ATAN: ArcTangent function which can be used as ATAN(X) SINH: Sinus Hyperbolic function which can be used as SINH(X) COSH: Cosinus Hyperbolic function which can be used as COSH(X) COTAN: which can be used as COTAN(X) TAN: which can be used as TAN(X) EXP: which can be used as EXP(X) LN: natural log, which can be used as LN(X) LOG: 10 based log, which can be used as LOG(X) SQRT: which can be used as SQRT(X) ABS: absolute value, which can be used as ABS(X) SIGN: SIGN(X) returns -1 if X<0; +1 if X>0, 0 if X=0; it can be used as SQR(X) TRUNC: Discards the fractional part of a number. e.g. TRUNC(-3.2) is -3, TRUNC(3.2) is 3. CEIL: CEIL(-3.2) = 3, CEIL(3.2) = 4 FLOOR: FLOOR(-3.2) = -4, FLOOR(3.2) = 3 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. Predefined functions that take two parameters are: INTPOW: The INTPOW function raises Base to an integral power. INTPOW(2, 3) = 8. Note that result of INTPOW(2, 3.4) = 8 as well. POW: The Power function raises Base to any power. For fractional exponents or exponents greater than MaxInt, Base must be greater than 0. LOGN: The LogN function returns the log base N of X. Example: LOGN(10, 100) = 2 MIN: MIN(2, 3) is 2. MAX: MAX(2, 3) is 3. MOD: MOD(x,y) function implements the Java % (modulus) operator. Predefined functions that take three parameters are: IF: The IF(b, case1, case2) function provides branching capability. If b is not 0, then it returns case1, else it returns case2. Behavior is similar to Java's: return b ? case1 : case2; If b==0 then case1 will not be evaluated, and vice versa. Example: IF(HEIGHT, 3/HEIGHT, 3) will make sure 3/HEIGHT does not cause division by zero.