IF

Returns one value if a specified condition evaluates to true or another value if the condition evaluates to false.

Category

Logical

Column Name

Select a column name from the list.

Condition

Select a comparison operator, such as greater than, less than, or less than or equal to.

Value

Select a measure name from the list, or type a value to which to compare the value in Column Name.

Value True

Select a value from the list, or type a value to appear in the cross tab if the Condition evaluates to true.

Value False

Select a value from the list, or type a value to appear in the cross tab if the Condition evaluates to false.

Returns

Data Analyzer evaluates the condition, compares the values, and displays the appropriate value for true or false.

Example

For an example using IF, review the content introducing Figure 4-8 and Figure 4-9.

Copyright Actuate Corporation 2012