Is there a way to use "ifnull" in a custom column?
For example, the below is not accepted, is there another way to accomplish this?
sales = [Quantity] * IFNULL( [Unit Price] ,0)
Hi @madkap
These are the functions available in Custom Expressions:
https://www.metabase.com/docs/latest/users-guide/expressions-list.html
You'll want to use coalesce:
https://www.metabase.com/docs/latest/users-guide/expressions-list.html#coalesce
2 Likes