Range Functions for Advisor Configuration Tables

Use range functions in input columns to simplify data entry and create smaller models for faster application load time. For example, instead of creating three separate rows in a Configuration table to create a rule that displays an exception message when a user selects the colors red, blue, and green, you can create one row and enter the range function (=Red,Blue,Green).

Note: For rules involving more than one code value, the syntax (=bm*) cannot be used; doing so causes an error when generating HTML files in Advisor. Instead, use the syntax (=bm1,bm2,bm3) or (=*).

Table 8-1shows examples of range functions:

Table 8-1 Examples of Range Functions

Range Function	Description
(=Red,Blue)	Anything equal to Red or Blue
(=1-3)	Anything that numerically matches, numbers only
(=*)	All
(!=Red,Blue)	Anything not equal to Red and not equal to Blue