You are here: Transaction Rules > Transaction Elements > Math Element > IIF

IIF

Description

IIF acts like an if-else statement. If the EXPRESSION attribute condition is true, then the first value is assigned to the MathVariable.  If false, the second value is assigned to the MathVariable. 

 

TYPE = IIF      

Element

Attributes

Attribute Value

Element Value

<MathVariable>

TYPE

IIF

Math variables or fields for each of the true and false conditions. They are separated by a comma. 

EXPRESSION

  

Condition to evaluate. See operators for more details.

 

DATATYPE

DATE / TEXT / INTEGER / DECIMAL

 

 

ROUND

Integer

Optional attribute may be used when DATATYPE="DECIMAL"

 

DEFAULT

String

 

 

LOG

Yes / No

Yes:  the result is stored in AsActivityMath table to be used by other activities.

No: the result is not stored. This is the default behavior.  

XML Example 

<MathVariable VARIABLENAME="APPEndDateMV" TYPE="IIF" EXPRESSION="DaysDiffOf(EffectiveDateMV,APPEndDateMV) 
 &lt;=0" DATATYPE="DATE">MaturityDate,APPEndDateMV</MathVariable>

Copyright © 2009, 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices