Configure Evaluation properties

EvaluationExpression

A basic expression to combine the source field value and quantity value with basic mathematical operations.

Click Browse (...) to open the Edit Evaluation Expression Editor. Define an expression that represents the combined value of the source fields.

Fields are referenced by name in the expressions and are required to be enclosed in square brackets.

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

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

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

• You can define a different expression for an evaluated field with the same name at a different reporting point, for the same module. The expressions is invoked per location to make sure results are consistent.

  ProductionPoint1.Fields.MyEvaluatedField.EvaluationExpression = “[MySource] * 10”

  ProductionPoint2.Fields.MyEvaluatedField.EvaluationExpression = “[MySource] * 20”

• It is possible to filter by all evaluated fields, including those that reference other evaluated fields, and those that reference Calender or Tariff lookup values.

• Handling of “division by zero” cases.

  • A field that is the result of a division has a data type of Double.

  • The result of a “division by zero” is Infinity.

  • The result of a “division by NULL” is NULL.

• If you prefer the result to be zero, you can check the divisor with the IIF operator. The > operator returns False when the right-hand operand is zero or less, or if its value is NULL.

  IIF([DivisorField] > 0, [DividendField] / [DivisorField], 0)

  Note: Any constant used in the expression should not be enclosed in parenthesis. For example: (([S1][S2])/100*30000)*(-1) - Invalid

Notice that constants 100 and 30000 are not enclosed in parenthesis, but -1 is.

[Source] * [Quantity]

SourceFields

The field definition that is be used as the source in the Evaluation Expression.

Click Browse (...) to open the Select Source Fields dialog box. Select the source fields for the evaluated expression.

Only fields under the current Production reporting point are available to use as source fields. However, an evaluated field can use another evaluated field as source.

Note: Calendar lookups are not supported as a source field to an evaluated field.