NULLIF

Applies to: sql

NULLIF(a, b) returns NULL when a equals b; otherwise it returns a. It is useful for avoiding divide-by-zero.

revenue / NULLIF(users, 0)

See also: null, coalesce