Custom column calculation based off value in another column

Hello. I am trying to add a custom column that adjusts some numbers depending on a text value in another field.

This is what I thought that should do it:
"SumIf([Revenue], contains([Product Name], "apples")) / 100"

Product Name can be "Red Apples", "CoolApples", etc.

But I am getting an error when I try the above:
Value does not match schema: {:query {:expressions {:Adjusted Revenue (named (not (some-matching-condition? a-clojure.lang.PersistentVector)) "Must be a valid instance of one of these clauses: :expression, :field")}}}

Using Metabase 0.41.1 on a Mac, PostgreSQL db

Hi @tjk
Can you include the full stacktrace from Admin > Troubleshooting > Logs, since I'm not sure why it's not working for you, but I guess you're doing something else.
Example custom expression SumIf([Price], contains([Category], "G"))

Might have been doing smth wrong.
Ended up using "case" expression instead.