topic Re: Field calc failure, division? in Geoprocessing Questions https://community.esri.com/t5/geoprocessing-questions/field-calc-failure-division/m-p/538049#M17855 <HTML><HEAD></HEAD><BODY><SPAN>Is there any case where [Previous] = 0? If so, ArcMap gets confused when dividing by 0 (I bet your cheap calculator does, too). Skip over 0s with the code block.</SPAN></BODY></HTML> Fri, 04 Nov 2011 20:54:53 GMT DarrenWiens2 2011-11-04T20:54:53Z Field calc failure, division? https://community.esri.com/t5/geoprocessing-questions/field-calc-failure-division/m-p/538048#M17854 <HTML><HEAD></HEAD><BODY><SPAN>I'm trying to a percent change for some fields.&nbsp; I have the amount increased by, and I have the previous value.&nbsp; So I made a new field, and asked the field calc to [Increase] / [Previous].&nbsp; It fails, and gives me the following.</SPAN><BR /><BR /><SPAN>General error executing calculator.</SPAN><BR /><SPAN>ERROR 999999: Error executing function.</SPAN><BR /><SPAN>Overflow</SPAN><BR /><SPAN>Failed to execute (CalculateField).</SPAN><BR /><BR /><SPAN>It's a fairly basic operation, and works even on a cheap calculator.&nbsp; Anyone know what I'm doing wrong?</SPAN></BODY></HTML> Fri, 04 Nov 2011 20:21:56 GMT https://community.esri.com/t5/geoprocessing-questions/field-calc-failure-division/m-p/538048#M17854 ForrestEnglish 2011-11-04T20:21:56Z Re: Field calc failure, division? https://community.esri.com/t5/geoprocessing-questions/field-calc-failure-division/m-p/538049#M17855 <HTML><HEAD></HEAD><BODY><SPAN>Is there any case where [Previous] = 0? If so, ArcMap gets confused when dividing by 0 (I bet your cheap calculator does, too). Skip over 0s with the code block.</SPAN></BODY></HTML> Fri, 04 Nov 2011 20:54:53 GMT https://community.esri.com/t5/geoprocessing-questions/field-calc-failure-division/m-p/538049#M17855 DarrenWiens2 2011-11-04T20:54:53Z Re: Field calc failure, division? https://community.esri.com/t5/geoprocessing-questions/field-calc-failure-division/m-p/538050#M17856 <HTML><HEAD></HEAD><BODY><SPAN>Also, make sure the target field type is Double with sufficient storage to hold the resulting value.</SPAN></BODY></HTML> Sun, 06 Nov 2011 16:47:53 GMT https://community.esri.com/t5/geoprocessing-questions/field-calc-failure-division/m-p/538050#M17856 NobbirAhmed 2011-11-06T16:47:53Z