Current Value function
- Last UpdatedMar 19, 2025
- 2 minute read
- PI System
- PI DataLink 2023 SP1
- Visualization
The Current Value function returns the most recent value of a historical PI point or PI AF attribute. For a future PI point, the value returned depends on the time stamps of recorded values relative to the current time:
-
If all recorded values have time stamps before the current time, the function returns the last recorded value.
-
If recorded values have time stamps that straddle the current time, the function returns an interpolated value.
-
If all recorded values have time stamps after the current time, the function returns no data.
Current Value is a volatile function: the function recalculates and updates values whenever Excel calculates or recalculates any cell in the worksheet. To force an immediate recalculation, press F9.
This function supports bulk calls.
|
Input |
Description |
|---|---|
|
Root path |
The common path to specified data items. Valid entries include:
|
|
Data item(s) |
One or more PI point names or PI AF attribute names, for which the function returns values. To specify multiple data items, enter a range of cells that contain PI point names or PI AF attribute names. The function returns values for each. Required. |
|
Output cell |
The worksheet cell where the function writes the resulting function array. If you select a cell before you open the function task pane, PI DataLink inserts the selected cell into the Output cell field. Specify the top-left corner of the function array. PI DataLink expands the range downward and to the right of the output cell, as necessary to return specified data. PI DataLink might overwrite adjacent cells. If you specify a multi-cell array in the Output cell field and the specified array is larger than the resulting function array, PI DataLink pastes the function formula in the unneeded cells of the specified array. |
|
No time stamp |
Select this option to return only values.The function returns values in a column for a column of referenced data items, or returns values in a row for a row of referenced data items. |
|
Time at left |
Click this option to return two columns: the time stamp in the left column and the value in the right column. |
|
Time on top |
Click this option to return two rows: the time stamp in the top row and the value in the bottom row. |