IF AND Not Equal Statement

Question

Hi!

I am using syntax that looks like this: if [Is Buy/Sell] != "sell" && [TRADE_KEYWORD.BO_ProductType] = "FEES_BBL_ACCR" then 2800 else 2300 endif , but am receiving the error "Invalid type in operator ==". I am sure I am doing something very simple and obvious wrong, but I am not sure what exactly it is!

Kenda · Accepted Answer

@grsomer

Make sure both of the fields you're checking in your if statement are string fields and that the field you're creating with your output is a numeric field.