Comparing to a value in another column

In a conditional expression, you can compare the values of one column with the values of another column. For example, in a report that displays products, sales prices, and MSRP (Manufacturer Suggested Retail Price), you can create a conditional formatting rule that compares the sale price and MSRP of each product and highlight the names of the products whose sales price is greater than the MSRP. Figure 2-15 shows a condition comparing the sale price value with the MSRP value. If the sale price value is greater, the product name appears in bold.

Figure 2-15

Creating a rule that compares values in two columns

How to compare to a value in another column

1	On Conditional Formatting, choose Change Value.

2	On Value, select Use value from data field. A list of columns used in the report appears.

3	Select a column from the list, then choose OK. Conditional Formatting displays the column name in the comparison value field.

Figure 2-16 shows the report design with conditional formatting applied.

Figure 2-16

A report design with conditional formatting

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

BIRT iHub 2