CRM On Demand - Administration (MOSC)

MOSC Banner

Expression Builder IIF function

edited May 3, 2013 3:52AM in CRM On Demand - Administration (MOSC) 8 commentsAnswered ✓
Can I have the Iff function nested like the syntax below?

IIf([<pcDiscount__ITAG>]>'15' and [<Status>]=LookupValue("OPTY_STATUS", "New") and [<SalesStage>]='Submit Approval' or [<cDiscount_Amt_ITAG>] >'50000','Mike',IIf([<pcDiscount__ITAG>]<='15' and [<cDiscount_Amt_ITAG>] >='40000' and [<cDiscount_Amt_ITAG>] <='50000' and [<Status>]=LookupValue("OPTY_STATUS", "New") and [<SalesStage>]='Submit Approval', JoinFieldValue('<User>',[<OwnerId>],'<BusinessUnitLevel1>',IIf([<pcDiscount__ITAG>]<='10' and [<cDiscount_Amt_ITAG>] >='20000' and [<cDiscount_Amt_ITAG>] <='40000 and [<Status>]=LookupValue("OPTY_STATUS", "New") and [<SalesStage>]='Submit Approval',JoinFieldValue('<User>',[<OwnerId>],'<BusinessUnitLevel2>',[<pcDiscount__ITAG>]<='10' and [<cDiscount_Amt_ITAG>] >='10000' and [<cDiscount_Amt_ITAG>] <='20000' and [<Status>]=LookupValue("OPTY_STATUS", "New") and [<SalesStage>]='Submit Approval', JoinFieldValue('<User>',[<OwnerId>],'<BusinessUnitLevel3>','<BusinessUnitLevel3>')))

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center