Error in formula

[Drus]

Why would the following formula return an error?

totext({SO_23CRWInvoiceDetail.QtyShipped}/{IM_90_UDF_IM_Masterfile.Weight}) + " " + totext({IM_90_UDF_IM_Masterfile.Label})

When I save the formula in Crystal it does not find an error, yet when I preview the report the error pops up. &ru

 

[mbarron]

What error appears? Without the error, a wild guess is a division by zero error???

If that is your error then add a zero check:

if {IM_90_UDF_IM_Masterfile.Weight}<>0 then

totext({SO_23CRWInvoiceDetail.QtyShipped}/{IM_90_UDF_IM_Masterfile.Weight}) + &quot; &quot; + totext({IM_90_UDF_IM_Masterfile.Label}) Mike