Supported Operations for point_expression Field

The point_expression field supports the following operations:

Arithmetic

+, -, /, *, ), (.

Include any point types except Boolean and floating point.

Logical

AND, OR, XOR, NOT.

Can include only Boolean points types.

Bitwise

BAND, BXOR, BNOT.

Can contain only Boolean and integer point types.

Relational

LT, GT, EQ, LE, NE, GE.

Functions

ALARM(), A2(), WARNING(), A1(), ALARM_HI(), AH2(), ALARM_LO(), AL2() WARNING_HI(), AH1(), WARNING_LO(), AL1(), and AL()

Return a Boolean result depending on the alarm state of the point.

 

ALARM_NOT_ACKED() and ANA()

Return a Boolean result depending on whether the alarm has been acknowledged or not.

 

EUCONV()

Returns the engineering units value of the point.

 

(expr1) ^ (expr2)

Raises expr1 to expr2 value

 

 

(expr1) ? (expr2) : (expr3) tests if expr2 is TRUE then expr2 else expr3

 

SQR (<point_id>)

Returns the square root of the point's raw value

 

ABS(expr)

Returns the absolute value of expr

 

ACOS(expr)

Returns the arc cosine of expr

 

ASIN(expr)

Returns the arc sine of expr

 

ATAN(expr)

Returns the arc tangent of expr

 

CEIL(expr)

Returns the closest integer to expr that is larger

 

COS(expr)

Returns the cosine of expr

 

EXP(expr)

Returns the value of e raised to expr

 

FLR(expr)

Returns the closest integer to expr that is smaller

 

LOG(expr)

Returns the natural logarithm (base e) of expr

 

LOG10(expr)

Returns the base 10 logarithm of expr

 

(expr1) MAX (expr2)

Returns the maximum value of expr1 and expr2

 

(expr1) MIN (expr2)

Returns the minimum value of expr1 and expr2

 

(expr1) MOD (expr2)

Returns the mod value of expr1 based on expr2

 

RND(expr)

Rounds expr to the nearest integer

 

(expr1) SHL (expr2)

Shifts expr1 left expr2 bits

 

(expr1) SHR (expr2)

Shifts expr1 right expr2 bits

 

SIN(expr)

Returns the sine of expr

 

TAN(expr)

Returns the tangent of expr

 

TRUNC(expr)

Truncates expr to its integer value

More information

Derived point file (DERIVED_POINT).