Running Sage 100 v2016. Have a VI job that imports data that typically contains a numeric value (the field is Quantity) as well as a total unit price. The import file does not have a per unit price but it's needed. In order to get the unit price I added two temp fields (Temp001 is the total unit price and Temp002 is the Quantity). I then added a calculation for Unit Price as Temp001 / Temp002. This all works well until a record comes in with no quantity...then I get the divide by zero error.
I added a "Skip" option within the Record tab to skip any record that contained "0.00" in the Quantity field but that doesn't seem to work. Any ideas would be helpful.
Thank you