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 Calculation Type, IF appears.
*
*
*
*
*
Figure 4-8  
Figure 4-9 displays the resulting cross tab, which displays the Revenue Rating column containing values of Very good and Poor.
Figure 4-9  

Additional Links:

Copyright Actuate Corporation 2012