Rockwell Automation FactoryTalk Metrics User Guide - Manual (Page 104)

Chapter 3 Collecting Performance Data
The Expression Editor is a FactoryTalk Transaction Manager tool
that you can use to create expressions, the result of which can be
passed to a column in a database table or a parameter in a stored
procedure in a database. After all data has been collected, expressions
are evaluated. If the data points cannot be collected in the defined
time period (data retrieval), the selected data point substitution
policy determines the value that is used in the expression.
The following operations and functions are available in the
Expression Editor:
• Logical and mathematical operations (page 104).
• Time format and processing functions (page 105).
• Data point functions (page 106).
• Advanced functions (page 109).
Use the mathematical operators listed in the following table to
perform calculations in defining an expression string. Once an
expression has been defined, the syntax and semantics are checked to
determine if it can be evaluated at run time. The results are then
passed to the enterprise connector for storage.
Arithmetic Bitwise Logical
+ (addition) & (AND) > (greater than)
- (subtraction) | (inclusive OR) < (less than)
% (modulus) ^ (exclusive OR)
>= (greater than or equal
to)
* (multiplication) >> (right shift) <= (less than or equal to)
/ (division) << (left shift) == (equal to)
\ (integer division) != (not equal to)
( (left parenthesis) && (logical AND)
) (right parenthesis) || (logical OR)
Using the Expression Editor
Logical and Mathematical
Operations
104 Rockwell Automation Publication PLTMT-UM001M-EN-P-June 2014