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