Comparing to a literal value

The conditional expression, as shown in Figure 3-9 in the previous section, evaluates the Credit Limit column and compares each value to determine if it matches a value between 100000 and 200000. The 100000 and 200000 values are literal values that you type.

Alternatively, you can select a value from the list of values in the Credit Limit column. Selecting from a list of values is useful if the comparison value is a customer name and you do not know the exact customer 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, Interactive Viewer 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, choose Change Value, below the Condition field.

Select Values appears. Choose Specify literal value, then choose Select Values. The values in the selected column appear. Figure 3-10 shows an example of the values in the credit limit column.

Figure 3-10

Selecting values

2	Select a value from the list, then choose OK. The value appears in the comparison value field on Conditional Formatting.

© Copyright OpenText Corp. All rights reserved. Privacy Policy | Cookie Policy

BIRT iHub 2