IIF
The IIF math variable is used as an IF-Else statement for evaluation and assignment of a new math variable. If the expression in the EXPRESSION attribute condition is true, the True Result is assigned to the New Math Variable. If the expression in the EXPRESSION attribute condition is false, the False Result is assigned to the new math variable.
The EXPRESSION, TRUE RESULT, and FALSE RESULT may use hard-coded default values/literal values, previously defined math variables, or a combination of both.
IIF Math Variable in Palette
Note: For a comprehensive explanation of the characteristics of this math variable, refer to the XML Configuration Guide in the Help menu.
Define the IIF Math Variable
Drag and drop the IIF Math variable from the Palette window onto the Math Pane. Enter the following information for the math variable.
-
Type a name in the Name field. This is required.
-
The data types are Activity, Boolean, Date, Decimal, Integer, Map, Object, and Text. This is required.
-
Make sure variable type is defined as IIF. This is required.
-
Select Yes or No from Log field. Default is No. This is an optional field.
-
Round offers the options of Yes or No. Round is only enabled if you select the Decimal in the data type property. If you would like to round the Decimal, select Yes. Enter the number of decimal places to round the result value. Note: When the data type of Decimal is selected, the default value for Round is set to No. You must change the selection of the radio button to Yes if you wish to round.
-
In the Expression property, enter the condition you would like to evaluate.
- In the True Result, enter the value you would like to assign to the math variable in the case the expression result is evaluated to True.
- In the False Result, enter the value you would like to assign the math variable in the case the expression result is evaluated to False.
Check-in the transaction to save the information to the database.
Copyright © 2009, 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices