Define equations for formula data references
- Last UpdatedJan 11, 2023
- 3 minute read
- PI System
- PI Server 2024 R2
- PI Server
Define equations for use in formula data references.
-
To add a new formula row, click
next to the Equations field.
You can also click in the text area and type in an equation.
-
Type an equation directly or build your equation from a list of available variables, operators, functions, and substitution parameters. Click
to choose from the following actions:
To ...
Do this ...
Enter a variable
Click Variables and click a letter on the alphabetized list.
Enter an operator
Click Operators and click an operator on the list. Valid operators are listed in List of formula data reference operators.
Enter a function
Click Functions and click a function on the list. Valid functions are listed in List of formula data reference functions.
Enter a substitution parameter
Click Substitution Parameters and click a time substitution parameter. For elements and transfers, only %Time% is available, but for event frames you can select from %StartTime, %EndTime%, %UtcTime%, %UtcStartTime%, %UtcEndTime%, and %Duration%. For more information on these parameters, see List of PI AF substitution parameters.
Numbers are converted to a double, time spans to a duration in seconds, and timestamps to UTC seconds.
-
To add another row to the formula, click
and continue the formula. Repeat as needed until you have completed the formula.
-
To change the formula, choose from the following actions:
To ...
Do this ...
Remove the selected equation from the calculation sequence
Select the row you wish to remove and click
.
Remove all equations from the calculation sequence
Click
.
Move an equation up or down in the calculation sequence
Select the row to be moved and click
or
.