Supported scalar functions
- Last UpdatedJan 25, 2024
- 1 minute read
AVEVA Historian Client Web supports using scalar functions in expressions. These functions have a 1:1 relationship between the values in the input and output streams.
The following scalar functions are supported:
|
Function |
Purpose |
|
ABS |
Calculates the absolute value of a stream. |
|
CASTUOM |
Changes a stream's unit of measure without changing the values. |
|
IF |
Produces a stream based on the results of a logical expression. |
|
IFBAD |
Overrides "bad" quality values in a stream. |
|
IFLONGER |
Evaluates whether or not a logical expression is true over a period greater than or equal to a specified time interval, and returns a TRUE or FALSE value or stream. |
|
IFSHORTER |
Evaluates whether or not a logical expression is true over a period shorter than a specified time interval, and returns a TRUE or FALSE value or stream. |
|
IFSTALE |
Replaces values from the input stream that are older than a specified interval with an alternative value. |
|
LOG |
Calculates the base 10 logarithm of a stream's values. |
|
ROUND |
Rounds a stream's values to two decimal places. |
|
SIGN |
Replaces a stream's values with 1 or -1 based on the current value's sign. |
|
SQRT |
Calculates the square root of a stream's values. |
|
TIMESHIFT |
Shifts the time stamps in a stream by a specified time interval. |
|
TRUNCATE |
Removes the fractional portion of a stream's values. |
|
UOM |
Converts a stream's values to a specified unit of measure. |