Comparing Input in two columns

[Chirag_Gandhi07]

So I am trying to check whether certain data in one column is equal to the data from another column. So if one row is 100.00 and that is the same in the other column, I want to know about it. If they match, they should output a 0, and if not, a 1. I am getting an invalid type in operator ==. message. What I did is:

IF [Contract Payment Amount] == [Sum of BASE PAYMENT ] THEN 1 ELSE 0 ENDIF

The two column names are Contract Payment Amount and Sum of BASE PAY

[NicoleJohnson · Accepted solution]

If you're getting an error that says Invalid type in Operator, that generally indicates that one of your fields is not the same data type (so either Contract Payment Amount or Sum of Base Payment is a string data type while the other is numeric). If you put a Select tool before your formula tool, you should be able to check the data types and make sure they are both numeric, then your formula will work as written!

NJ

[Chirag_Gandhi07]

Yes it worked after I changed the data types to the same. Thank you so much!

[simasarry]

Does it work if the columns to compare are in two different files ? like the vlookup function in excel?