Home of the ColdFusion Community
|
Mailing Lists
|
Home / Groups / SQL
NullIf and Divide By ZeroThank you for the guidance. You suggestion and another tweak helped me get this functioning: avg (isNull(((docunitprice * orderqty)-((c.avglaborcost + c.avgburdencost + c.avgmaterialcost + c.avgsubcontcost + c.avgmtlburcost)*d.orderqty))/ nullIf(docunitprice * orderqty, 0),0))as PercValueAdd |
May 22, 2013
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||
