>No need for three COALESCEs if you want to multiply: >and coalesce(p.total_revenue*p.exchange_rate*p.cgsshare_pct,0) = 0))
There are cases where these variables may have null values. Regards, Nols Smit . [Non-text portions of this message have been removed]
