>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
