1.2. Use Expression Editor Operations

Edit expression operations are available in the Edit Expression dialog box.

	Arithmetic operations.
	Bitwise operations.
	Alarm functions.
	Conversion operation.
	Logical operations.
	Relational operations.
	Scientific operations.

Arithmetic Operations

-	Subtraction
*	Multiplication
/	Division
	The result of dividing two integers in an expression will be an integer. If you want a floating point result, multiply the numerator by 1.0 before dividing. Example
	POINTA	Set to 6.
	POINTB	Set to 4.
		Result of the expression POINTA/POINTB is 1 (POINTA*1.0)/POINTB is 1.5.
+	Addition
^	Value of X raised to the power of Y.
SQR	Takes the square root of an expression.
	Format	SQR expr
ABS	Takes the absolute value of an expression.
	Format	ABS (expr) Example ABS (-2.6) return 2.6
MIN	Returns the minimum value of two expressions.
	Format	(expr1) MIN (expr2) Example 3 MIN 4 returns 3.
MAX	Returns the maximum value of two expressions.
	Format	(expr1) MAX (expr2) Example 3 MAX 4 returns 4.
MOD	Returns the modulus value of an expression.
	Format	(expr1) MOD (expr2) Example 9 MOD 8 returns a value of 1.
RND	Rounds a floating-point expression to the nearest integer.
	Format	RND (expr) Example RND (2.6) returns a value of 3. RND (-2.6) returns a value of -3.
TRUNC	Truncates a floating-point expression to its integer value.
	Format	TRUNC (expr) Example TRUNC (2.6) returns a value of 2. TRUNC (-2.6) returns a value of -2.
FLR	Rounds a floating-point expression to the nearest integer that is smaller than the expression.
	Format	FLR (expr) Example FLR (2.6) returns a value of 2. FLR (-2.6) returns a value of -3.
CEIL	Rounds a floating-point expression to the nearest integer that is larger than the expression.
	Format	CEIL (expr) Example CEIL (2.3) returns a value of 3. CEIL (-2.3) returns a value of -2.

Bitwise Operations

You can use Boolean, integer or floating point number for Bitwise operations. If a number/expression is in floating point, it is rounded off to the nearest integer for these operations.

BAND	Performs	bitwise AND of two expressions.
	Format	<expr1> AND <expr2>
BOR	Performs	bitwise OR of two expressions
	Format	<expr1> OR <expr2>
BNOT	Performs	bitwise NOT of an expression
	Format	NOT <expr>
BXOR	Performs	bitwise XOR of two expressions.
	Format	<expr1> XOR <expr2>
SHL	Performs	binary left shift on an expression.
	Format	(expr1) SHL (expr2) Example 2 SHL 1 returns a value of 4. Note: When SHL goes out of range the: Point becomes unavailable. Point Control Pane is starred. Core status log notes that it is unavailable.
SHR	Performs	a binary right shift on an expression.
	Format	(expr1) SHR (expr2) Example 2 SHR 1 returns a value of 1 Note: When SHR goes out of range the: Point becomes unavailable. Point Control Pane is starred. Core status log notes that it is unavailable.

Alarm functions

Alarm functions supported by the Expression Editor are:

AL	Returns	TRUE if the point is in any Alarm or Warning state.
	Format	AL(<point id>)
A1 or WARNING	Returns	TRUE if the point is in a Warning High or Warning Low state.
	Format	A1(<point id>)
A2 or ALARM	Returns	TRUE if the point is in an Alarm High or Alarm Low state.
	Format	A2(<point id>)
AH1 or WARNING_HIGH	Returns	TRUE if the point is in a Warning High state.
	Format	AH1(<point id>)
AH2 or ALARM_HIGH	Returns	TRUE if the point is in an Alarm High state.
	Format	AH2(<point id>)
AL1 or WARNING_LOW	Returns	TRUE if the point is in a Warning Low state.
	Format	AL1(<point id>)
AL2 or ALARM_LOW	Returns	TRUE if the point is in an Alarm Low state.
	Format	AL2(<point id>)
ANA or ALARM_NOT_ACKED	Returns	TRUE if the point is in alarm and the alarm has not been acknowledged. Note: The ANA behavior was changed in CIMPLICITY V.6.1. Prior to V.6.1 it behaved as NACK. The global parameter PTEXP_ANA_EQ_NACK_AND_AL is available to revert ANA behavior to pre-version 6..
	Format	ANA(<point id>) Important: ANA is not supported for Enterprise points.
NACK	Returns	TRUE if the alarm has not been acknowledged, whether or not the point is in an alarm state.
	Format	NACK (<point id>)

Conversion operation

VAL	Convert a variable that consists of numbers in text string format to a numeric format that can be included in calculations.

Logical operators

You can use Boolean, integer or floating point numbers for logical operations. If an expression has a non-zero value, it is TRUE; if the value is zero, it is FALSE.

AND	Performs	Logical AND of two expressions.
	Format	<expr1> AND <expr2>
IF…ELSE	Performs	Logical if A is TRUE, then B, else C.
	Format	If (expr1) THEN (expr2) ELSE (expr3) Or (expr1) ? (expr2) : (expr3)
		Note: The IF…ELSE statement is not available from the operation keys. However, you can enter it manually.
OR	Performs	Logical OR of two expressions.
	Format	<expr1> OR <expr2>
NOT	Performs	Logical NOT of an expression.
	Format	NOT <expr>
XOR	Performs	Logical XOR of two expressions.

Relational operations

LT	Less Than or Below
	Format	(expr1) LT (expr2
GT	Greater Than or Above.
	Format	(expr1) GT (expr2)
EQ	Equal To
	Format	(expr1) EQ (expr2)
LE	Less Than or Equal To
	Format	(expr1) LE (expr2)
GE	Greater Than or Equal To
	Format	(expr1) GE (expr2)
NE	Not Equal To
	Format	(expr1) NE (expr2)

Scientific operations

SIN	Returns	sine (angle in radians) of an expression.
	Format	SIN (expr)
COS	Returns	cosine (angle in radians) value of an expression.
	Format	COS (expr)
TAN	Returns	tangent (angle in radians) of an expression.
	Format	TAN (expr)
ASIN	Returns	Arc sine (angle in radians) value of an expression.
	Format	ASIN (expr)
ACOS	Returns	Arc cosine (angle in radians) value of an expression.
	Format	ACOS (expr)
ATAN	Returns	arc tangent (angle in radians) value of an expression.
	Format	ATAN (expr)
X^Y	Raise a value to a power.
	Format	<value> ^ (<power>)
EXP	Returns	exponential (ex) value of an expression where x is the expression.
	Format	EXP (expr)
LOG	Returns	natural logarithm (base e) of an expression.
	Format	LOG (expr)
LOG10	Returns	base 10 logarithm of an expression.
	Format	LOG10 (expr)

More information

1. Expression Editor in CimEdit.