Navigation:  How to > The Report Wizard > The Report Wizard Step 3: Create Work Field Columns > Definition of all Operators > Value List

A value list is a list of values that can be used on the right side of = or <> operators. When you use a value list, if the expression on the left side of the = is equal to any of the values in the list, the expression is true. If the expression on the left side of the <> operator is not equal to any of the values in the value list then the expression is true. The list may include single values or value ranges separated by commas. A value range is a start value, then a ~, then the end value.

 

The following are some examples of expressions using value lists and their results. For these examples, assume that the field MyCode contains the number 4, and that the field OtherCode contains the number 10.

 

MyCode <> 1, 2, 3, 10, 12                 Result: true; 4 is not equal to any list value

OtherCode <> 1, 2, 3, 10, 12                 Result: false; 10 is equal to one of the list values

MyCode = 1, 3~7, 11                         Result: true; 4 is in the range of 3 through 7.

MyCode <> 1, 3~7, 11                         Result: false; 4 is in the range of 3 through 7.