>Your posting gave me an idea.

Good to hear, it's always better that the question maker finds the solution than the helpers!

> and coalesce(p.total_revenue,0) * coalesce(p.exchange_rate,0) * coalesce(p.cgsshare_pct,0) = 0))

No need for three COALESCEs if you want to multiply:

and coalesce(p.total_revenue*p.exchange_rate*p.cgsshare_pct,0) = 0))

Set