Supported scalar functions
- Last UpdatedFeb 06, 2025
- 1 minute read
AVEVA Insight 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 |
|
Calculates the absolute value of a stream. |
|
|
Changes a stream's unit of measure without changing the values. |
|
|
Produces a stream based on the results of a logical expression. |
|
|
Overrides "bad" quality values in a stream. |
|
|
Calculates the base 10 logarithm of a stream's values. |
|
|
Rounds a stream's values to two decimal places. |
|
|
Replaces a stream's values with 1 or -1 based on the current value's sign. |
|
|
Calculates the square root of a stream's values. |
|
|
Shifts the time stamps in a stream by a specified time interval. |
|
|
Removes the fractional portion of a stream's values. |
|
|
Converts a stream's values to a specified unit of measure. |