Alternative to " = " in Bool

[vvissamsetty]

I have two columns with True and False - Bool data type. Column A is my input data which is Bool and Column B is the data I created. I'm trying to create a check function for these two columns which is 

IF [QCC Treatment For Straddle Purposes] = [QCC Treatment for Straddle Purposes - Alteryx]

THEN " "

ELSE "Error"

ENDIF

For column B(the data I'm creating) - I cant have the "=" in the formula as Bool doesn't accept this operator.

IF [Option is deep In the Money - Alteryx] = "False" && [Qualified Exchange] = "True" && [Is Grant Date > 30 Days from Expiration] = "True" && [Not Granted by Options Dealer] = "True"

THEN "True"

ELSE "False"

ENDIF

I cant change this to String as my input data from file is changing "True/False" into "T/F" and I'm unable to match Column A = Column B. Is there any other alternative way for "=" in Bool?

[Thableaus · Accepted solution]

Hi @vvissamsetty 

Try this:

IF NOT [Option is deep In the Money - Alteryx]  && [Qualified Exchange]  && [Is Grant Date > 30 Days from Expiration]  && [Not Granted by Options Dealer]

THEN "True"

ELSE "False"

ENDIF

You don't need the "=" sign, just need to use your fields as the clauses.

Cheers,

[vvissamsetty]

Awesome @Thableaus. Thanks for the help.