Need a little help converting a Excel Formula to an Alteryx Expression.
The formula from Excel.
=IF(AND(CM3<>TRUE,OR(CD3,CK3)),TRUE,FALSE)
My interpretation is
IIf ([Auto Exclude]!='True' AND [No Consumption last 24 months] OR [<$10K],'True','False'
I need a little guidance on the syntax... or if the formula for alteryx needs to broken up into multiple if statements than can work too. Just a little stuck here.
Thank you.
Solved! Go to Solution.
IIf([Auto Exclude]!='True' AND ([No Consumption last 24 months] = 'True' OR [<$10K] = 'True'),'True','False')
I am getting an invalid operator message
@Iamironman Can you check your data type of the field [Auto Exclude]? also if possible can you screen shot your formula tool with data?