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!
Solved! Go to Solution.
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.
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.