Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

Asset Framework and PI System Explorer (PI Server 2024 R2)

Define equations for formula data references

  • Last UpdatedJan 11, 2023
  • 3 minute read

Define equations for use in formula data references.

  1. 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.

  2. 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.

  3. To add another row to the formula, click and continue the formula. Repeat as needed until you have completed the formula.

  4. 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 .

TitleResults for “How to create a CRG?”Also Available in