Expressions 

MDM expressions are Excel-like formulas that are evaluated by MDM and return a distinct value for each record. Using MDM expressions, you can define complex formulas based on the data values of the record, and then evaluate those formulas against a group of one or more records, all without using a query language.

You can also define category-specific expressions as branches of a single expression, and MDM automatically executes the applicable expression based on the value of the category for each record.

Expressions appear within MDM in a variety of contexts, including validations, assignments, and calculated fields (calculated fields are described in the MDM Console Reference Guide).

For more information about expressions, see MDM Expressions.

Unlike an Excel formula, an expression is token-based, so that you do not have to type field, attribute, qualifier, operator, or function names, and can instead select them from drop-down lists, reducing the potential for typing error.