Posted Fri, 30 Aug 2013 12:25:00 GMT by Portal Admin

I am getting a "Data Mapping Error - Code 9 (Divide by Zero)" when using the following CASE expression:
CASE
WHEN LYTDMos<>0 AND LYTDLbsOH<>0 THEN FLOAT(LYTDLbsOH/LYTDMos)
ELSE FLOAT(0)
END

I am using the FLOAT function since this result is going to be used in a following expression which also involves division so the I get the most accurate results.

I have verified that the two fields are actually each 0 and not null.

Yet I continue to get the data mapping error.

This is happening arbitrarily in various expressions where the same type of CASE expression exists to eliminate the error occuring.

Has anyone else had this type of problem before with SEQUEL.

Due to this error occurring data is being lost in a critical report for inventory management.

Any ideas or comments would be greatly appreciated.

Thank in advance!

Posted Thu, 16 Jun 2016 05:00:00 GMT by Portal Admin

Hi there~~

Best thing to do, would be to call, email or chat in on this problem, so we can look at your specific data more closely.

Phone: 952-933-0609

Email: [email protected]

Chat available on our Web site at www.sequel-software.com

 

Thanks!

Originally Posted By jdaugherty

You must be signed in to post in this forum.