The Condition Builder enables you to create conditional statements for formula and condition components. Conditional statements are also known as If...Then statements. If the first part (the If part) of a conditional statement is true, then the second part of the statement (the Then part) is also true. If the first part of a conditional statement is false, then the second part may or may not be true.
To create a conditional statement:
In the System View, expand the Financial Management, Planning, or Essbase application type, the application, the calculation type (for Financial Management), the plan type (for Planning), or the database (for Essbase), and Formulas. Do one of these tasks:
Right–click the formula for which you want to create a conditional statement, and select Open.
Select the formula for which you want to create a conditional statement, and select File, Open.
In the IF row that is displayed, enter the text of the conditional statement, or click the Add/Edit Condition icon to the right of the row to access the Condition Builder. The Condition Builder enables you to design a condition statement graphically.
Note:
Though you can select IF, ELSE IF, and ELSE from the down arrow, by default, the first statement must be an IF statement.
In the Condition Builder, select Metadata Condition or Data Condition.
Enter a value in Function (for a metadata condition) or Formula (for a data condition).
Click in the Function or Formula row to display the Actions icon. Click the Actions icon, and select an option to create a formula or function:
Variable (See Working with Variables.)
Member (See Working with Members.)
Function (See Working with Functions.)
= (equal to)
< (greater than)
> (less than)
<> (greater than or less than)
>= (less than or equal to)
<= (greater than or equal to)
Enter a value in Value.
Click in the Value row to display the Actions icon. Click Actions, and select an option to create a value for the formula or function:
Variable (See Working with Variables.)
Member (See Working with Members.)
Function (See Working with Functions.)
Click the + icon to add the condition to the Condition grid. (You can also use the + icon to create a copy of a selected row, and add it to the Condition grid.) Use the — icon to replace a selected row in the Condition grid with a metadata or data condition.
Tip:
Use the up arrow and down arrow icons to reorder the condition statements in the grid.
The condition is inserted into the IF statement.
Optional: Repeat step 2 through step 10 for each condition statement you want to create.
Optional: For each additional condition statement, double-click in the first column to display a dropdown list from which you can select an operator to start each condition statement:
IF: You can start only the first condition statement with IF. (This is the default that displays only for the first condition statement you create.)
NOT IF: You can start only the first condition statement with NOT IF.
AND: You can start any condition statement (except the first) with AND when you want to create a compound of at least two condition statements.
OR: You can start any condition statement (except the first) with OR when you want to create a compound of at least two condition statements.
AND NOT: You can start any condition statement (except the first) with AND NOT when you want to include the condition statement that follows it with the formula component.
OR NOT: You can start any condition statement (except the first) with OR NOT when you want to exclude the condition statement that follows it from the formula component.
Tip:
Use the Group and Ungroup icons to add and remove parentheses from condition statements. To group or ungroup multiple condition statements, use Ctrl + Click or Shift + Click to select the condition statements you want to group or ungroup.
The condition statements are inserted into the Condition row.