Condition Functions

ConditionalEvaluation

The ConditionalEvaluation function takes three arguments:

• A filter defined as a Filter resource that acts as the conditional expression,

• A value to return if the expression evaluates to True, and

• A value to return if the expression evaluates to False.

CustomConditional Evaluation

The CustomConditionalEvaluation function takes three arguments:

• A local filter (not defined in the Filters resource) that acts as the conditional expression,

• A value to return if the conditions evaluate to True, and

• A value to return if the conditions evaluate to False.

Enter the filter statement in the text field. Then create and edit local filter conditions through the Common Conditions Editor or Global Variables Selector:

ReplaceNull

The ReplaceNull function takes two arguments:

• A value to return from a test field, and

• If the value is Null, a replacement value to return from another field.

Both test and replacement fields must be of the same type. You can also set the replacement to a constant value. For example, for a String field, the replacement value can be something like Match found.