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