AnsweredAssumed Answered

Help with IIF statement

Question asked by monzay on Feb 17, 2017
Latest reply on Feb 18, 2017 by monzay

I'm trying to build a nested IIF statement in a dynamic table that will populate a field I'm using to show an image in my popup window on Portal.

 

Works: 

IIF([MUTCD_ID]="UNK", "no image",IIF([SIGN_CATEGORY]=1,"regulatory","no image"))

 

Doesn't work: 

IIF([MUTCD_ID]="UNK", "no image",IIF([SIGN_CATEGORY]=1,"regulatory/[MUTCD_ID]","no image"))

 

Row Info
Row Number 2
TableName: Sign
FieldName: EXISTING_IMAGE_LINK
ValueInfo: IIF([MUTCD_ID]="UNK", "no image",IIF([SIGN_CATEGORY]=1,"regulatory/[MUTCD_ID]","no image"))
ValueMethod: EXPRESSION
On Create: 0
On Change: 0

Checking for Subtype Restriction
Field Name: EXISTING_IMAGE_LINK was found at index: 31
Trying: EXPRESSION
replace field: SIGN_CATEGORY with a value
replace field: MUTCD_ID with a value
replace field: MUTCD_ID with a value
Checking to verify there is a field to store the expression
Expression to be eval: IIF("R7-1"="UNK", "no image",IIF(1=1,"regulatory/"R7-1"","no image"))
ERROR: evaluating the expression for feature in Sign with OID of 10419
Expected ')'
Finished: EXPRESSION

 

I don't know why it is expecting a closed parentheses. I've tried various things and it keeps throwing out this same error. The expression that works has the same number of parentheses. 

Outcomes