Add a Lot evaluated field

A Lot 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.

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

  Example

  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.

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

To add a Lot evaluated field

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

Related topics

• Add and configure a Lot reporting point

• Add a Lot custom field