PIExpVal()
- Last UpdatedNov 21, 2022
- 1 minute read
- PI System
- PI DataLink 2023 SP1
- Visualization
Returns the computed value of a performance equation at a specified time stamp.
Syntax
PIExpVal(Expression, TimeStamp, OutCode, RootPath)
Arguments
|
Argument |
Type |
Description |
|
Expression |
String |
One or more performance equations that the function computes a value for. See Expressions. To specify multiple expressions, enter a range of cells that contain complete expressions. The function returns values for each. |
|
TimeStamp |
String |
The time stamp for which the function returns values. See Time inputs. |
|
OutCode |
Integer |
An output code that determines what appended data the function returns and how the function orients output. See Output codes for information on how to compute the code. This function supports bits 1 and 2. |
|
RootPath |
String |
The path to the data item referenced by the expression. See Data items. |
Example
=PIExpVal("sqr('sinusoid')","y",0,"thevax")
Calculates the square root of the value of the PI point sinusoid from the Data Archive server named thevax at midnight yesterday.