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 MSRP.
3 Select a column from the list, then choose OK. The column name appears in the comparison value field on Conditional Formatting.Figure 3-11 shows a condition that compares the sales price with the MSRP value. If the sale price value is greater, the product name displays in bold.
Figure 3-11 You can now define up to two additional rules for the report column on Conditional Formatting. Choose OK. Figure 3-12 shows the conditional formatting applied to the report column.
Figure 3-12
|
|
Copyright Actuate Corporation 2012 |