IF AND Not Equal Statement

[grsomer]

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!

[CharlieS]

It might have to do with your result values and the field your expressions is assigned to. The default Formula field is a string type, if your results are 2800 and 2300 those are numeric values.

Try changing your field type to a numeric field, or adding quotes around 2800 and 2300 to make them string values.

[Kenda · Accepted solution]

@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.