About Material Quality Evaluated field

A Material Quality Evaluated field supports the creation of one or more evaluated fields, which do not have a normal expression, but have a formula; for example, pt * quantity / 1000.

• Evaluated fields are visible in the Inventory views, but not in the Quality standard view.

• 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 [Quantity] with hardcoded values and executes against the data repository connection to verify the expression is valid.

Example

[SourceField] * [Quantity] / 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.

• An evaluated field is able to reference fields that have an Action type of CalendarLookup or TariffLookup.

Related topics

• About Material Quality

• Add a Material Quality custom field

• Configure Material Quality hierarchy