Add a Production evaluated field

A Production evaluated field enables you to combine the values of other fields. You can define which source fields to use in the expression and create a formula that inserts the values of the defined source fields.

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

• You can use custom fields as well as standard fields as the source fields.

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

  EvaluatedField1.EvaluationExpression = “[MySource] * 10”

  EvaluatedField2.EvaluationExpression = “[EvaluatedField1] * 20”

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

To add a Production evaluated field

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

1. Right-click the Fields folder under the relevant Production 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 Production evaluated field properties.

Related topics

• About Production

• Add a Production custom field