Add a Calculated Quality evaluated field

A Calculated Quality evaluated field supports the creation of one or more evaluated fields that have a formula, instead of an historical expression.

For example:

SourceField * LotGroupBalance / 1000

• The DataType of an evaluated field defaults to Double.

• When you select source fields for the expression, only source fields that belong to the current reporting point are available.

• The EvaluatedFieldExpression property configured should be a valid expression. AVEVA™ Production Management replaces placeholder [LotGroupBalance] with hard-coded values and executes against the data repository connection to verify the expression is valid.

  Example:

  [SourceField] * [LotGroupBalance] / 100

  SELECT 1.0 * 2.0 / 100

• The syntax that can be used in the expression is defined in this Microsoft article on DataColumn.Expression Property.

• As long as a cyclic reference is not created, an evaluated field can reference another evaluated field.

To add a Calculated Quality evaluated field

You can add as many evaluated fields as you require and is practical.

1. Right-click the Fields folder under the relevant Calculated Quality reporting point and select Add Evaluated Field. The new evaluated field appears under the Fields folder.

   

2. Rename the field with a meaningful name.

3. Configure the properties. For guidance in configuring the properties, see Calculated Quality evaluated field properties.

Related topics

• About Calculated Quality

• Add a Calculated Quality evaluated field