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