Named formulas

Use named formulas to create and store formulas for repeated use. Named formulas allow you to modify a formula definition once, and have the modification propagate to each task or calculation that uses the named formula.

The variables '$sp' (output service point) and '$spc' (output service point channel) are used as references to retrieve readings from the database when processing a formula.

To fetch interval data not yet stored in the database, the variable '$input' directly references an interval stream of data passed into the UCE. This variable uses the passed-in data as the service point.

Note: Advanced formula supports either variable $input or $input:XX, but not if both are used in the same formula.

These instructions refer to basic formula construction. If the user has the proper security role assigned, there is also an Advanced tab where more complex formulas can be constructed either manually or using the Expression Builder, accessible by clicking on the Builder button.

For more information, see Creating named formulas.