Using a conditional expression in a cross tab

The IF function returns one value if a specified condition evaluates to true or another value if the condition evaluates to false. Using the IF function requires completing the following tasks, as shown in Figure 4-8:

In Measure Label, type text to appear in the heading, such as Revenue Rating.

In Select Category, select Logical.

In Calculation Type, IF appears.

In Column Name, select a database column name to compare to a value.

In Condition, select a comparison operator, such as Greater Than or Equal To.

In Value, type the value to which to compare the Column Name value, such as 100000.

In Value True, select a value or type the value to display if the condition evaluates to true, such as Very good.

In Value False, select a value or type the value to display if the condition evaluates to false, such as Poor.

Figure 4-8

Computed Measure displaying sample values for the IF function

Figure 4-9 displays the resulting cross tab, which displays the Revenue Rating column containing values of Very good and Poor.

Figure 4-9

Displaying cross tab results for the applied IF function

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

BIRT iHub 2