Comparing to a literal value
The conditional expression, as shown in
Figure 2‑13 evaluates the Profit column and compares each value to determine if it is between 1000 and 2000. The 1000 and 2000 values are literal values that you type. Alternatively, you can select from a list of values from the Profit column. Selecting from a list of values is useful if the comparison value is a product name, and you do not know the exact product names, or if the comparison value is a date, and you do not know the date format to type. If the comparison value is a date, BIRT Studio also provides a calendar tool, which you can use to select a date.
How to select a comparison value from a list of values
1 On Conditional Formatting, below the field that takes a comparison value, choose Change Value.
2 On Value, select Specify literal value, and choose Select Values. The values in the selected column appear.
Figure 2‑14 shows an example of the values in a product name column.
3 If there are too many values in the list, you can type a string in Filter Text to search for values that begin with that string. For example, you can type 18 to view all product names that begin with 18. You cannot search for strings that appear in the middle of a name.
Figure 2‑14 Selecting a comparison value
4 Select a value from the list, then choose OK. The value appears in the comparison value field on Conditional Formatting.
