Coalesce
Coalesce(a, b, …) · Scalar
SQL COALESCE: returns the first non-NULL argument. The standard tool for turning blank aggregates into zeros (Coalesce([Revenue], 0)) and for giving Switch a blank-safe scrutinee.
Example
Section titled “Example”RevenueOrZero := Coalesce([Revenue], 0)