Malformed formula with multiple if statements and criteria

[pattersonmichaelk]

Relatively new to Alteryx and struggling to get some formulas to work. Below is an example. Can someone potentially point me to where the malformed error is? The one new column I want to return true/false for has about 7 of these if statements.

IF [C.4.a. Asset Type] = "ABS-CBDO" AND [Industry_Group] = "Other Asset Backed Securities" THEN "True" ELSE "False" OR

IF [C.4.a. Asset Type] = "ABS-MBS" AND [Industry_Sector] = "Mortgage Securities" THEN "True" ELSE "False" OR

ENDIF

[Garabujo7 · Accepted solution]

Hello @pattersonmichaelk ,

I did some small changes and now is working:

IF [C.4.a. Asset Type] = "ABS-CBDO" AND [Industry_Group] = "Other Asset Backed Securities" THEN "True" elseif
[C.4.a. Asset Type] = "ABS-MBS" AND [Industry_Sector] = "Mortgage Securities" THEN "True" ELSE "False"
ENDIF

Hope this helps

Gabriel

[pattersonmichaelk · Accepted solution]

Thank you!

[Garabujo7]

Anytime!