>>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.

I know, Nols, if any of them are NULL, the result of multiplying them are NULL. So the one coalesce above is identical to the three coalesces that you used.

HTH,
Set