Custom Expression error: Expecting expression but found function contains returning boolean

Hello Everyone!

I am trying to create a very simple custom column/ expression using contains from a text-based column.

But it shows an error.

"Expecting expression but found function contains returning boolean"
CUSTOM Expressions error!

1 Like

Hey friend,

I'm a bit late to this, but I was having the same error and found this post on Google. It took me a minute, but I was able to get it working with a custom expression. Try: case(contains([commute_modes], "driving"), 1, 0)

Then in your 'Summarize' section, you can sum these rows up to get a count.

...Or if you're looking to return the value only if it contains "driving", you'd do something like this: case(contains([commute_modes], "driving"), [commute_modes], "Not a driving commute mode")