Dear Community Team
I have one formula field say MATCHED_OR_NOT and want to add below logic but this code is giving error. Can you please help me to analyze what is wrong with following code:
IF [GENDER1] = "E" OR ISNULL([GENDER1]) OR IsEmpty([GENDER1] THEN
IF [AGE_CALC] = [AGE_AT_ENTRY] THEN
"DIRECT - Y"
ELSE
"DIRECT - N"
ENDIF
ELSE
IF [ORIG_AGE] = [AGE_AT_ENTRY] THEN
"DIRECT - Y"
ELSE
"DIRECT - N"
ENDIF
ENDIF
Thank you.
Regards,
LadyN
Solved! Go to Solution.
Hi @LadyNaureen, you seem to missing a ) after .....OR IsEmpty([GENDER1]) THEN
Also, the function IsEmpty will return true for both Nulls and Empty cells, so you don't need the IsNull part in the first line.
Hope that helps.
In addition to @markcurry 's observation - you only need 1 endif - at the very end of your statement. I also rely upon a strict if/then/elseif/else/endif structure.
There are multiple other things though that could be going wrong - so if you can post some sample data, or screengrabs of the error messages that would be helpful in pinpointing other sources of errors - i.e. mismatched field types etc...