Ifnull custom column

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

1 Like