topic Calculate raito in Python Questions https://community.esri.com/t5/python-questions/calculate-raito/m-p/710537#M55073 <HTML><HEAD></HEAD><BODY><P>I need to calculate ratio between two numbers than to percent but some rows in both field1 and field2 have zero values.</P><P>Simple calculator field2 / field1 * 100 but field1 has zeros, how do I by pass the rows with zeros in field1 in field calculator?</P><P></P><P>Field 1&nbsp;&nbsp; field 2</P><P>0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15200 --&gt; can't divide 0/15200</P></BODY></HTML> Mon, 21 Sep 2020 15:23:40 GMT CCWeedcontrol 2020-09-21T15:23:40Z Calculate raito https://community.esri.com/t5/python-questions/calculate-raito/m-p/710537#M55073 <HTML><HEAD></HEAD><BODY><P>I need to calculate ratio between two numbers than to percent but some rows in both field1 and field2 have zero values.</P><P>Simple calculator field2 / field1 * 100 but field1 has zeros, how do I by pass the rows with zeros in field1 in field calculator?</P><P></P><P>Field 1&nbsp;&nbsp; field 2</P><P>0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15200 --&gt; can't divide 0/15200</P></BODY></HTML> Mon, 21 Sep 2020 15:23:40 GMT https://community.esri.com/t5/python-questions/calculate-raito/m-p/710537#M55073 CCWeedcontrol 2020-09-21T15:23:40Z Re: Calculate raito https://community.esri.com/t5/python-questions/calculate-raito/m-p/710538#M55074 <HTML><HEAD></HEAD><BODY><P>Are you doing this in python or just the field calculator?&nbsp; Either way, select out those records that meet your criteria then apply the calculation.</P></BODY></HTML> Mon, 21 Sep 2020 15:29:54 GMT https://community.esri.com/t5/python-questions/calculate-raito/m-p/710538#M55074 JoeBorgione 2020-09-21T15:29:54Z Re: Calculate raito https://community.esri.com/t5/python-questions/calculate-raito/m-p/710539#M55075 <HTML><HEAD></HEAD><BODY><P>Put the following in the expression box using a Python parser:</P><PRE class="language-python line-numbers"><CODE>!field2!<SPAN class="operator token">/</SPAN>!field1!<SPAN class="operator token">*</SPAN><SPAN class="number token">100</SPAN> <SPAN class="keyword token">if</SPAN> !field1! <SPAN class="keyword token">else</SPAN> None<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE></BODY></HTML> Mon, 21 Sep 2020 15:40:53 GMT https://community.esri.com/t5/python-questions/calculate-raito/m-p/710539#M55075 JoshuaBixby 2020-09-21T15:40:53Z Re: Calculate raito https://community.esri.com/t5/python-questions/calculate-raito/m-p/710540#M55076 <HTML><HEAD></HEAD><BODY><P>Ya I could have done it that way but I want to know who to do it through field calculator.</P></BODY></HTML> Mon, 21 Sep 2020 15:42:36 GMT https://community.esri.com/t5/python-questions/calculate-raito/m-p/710540#M55076 CCWeedcontrol 2020-09-21T15:42:36Z Re: Calculate raito https://community.esri.com/t5/python-questions/calculate-raito/m-p/710541#M55077 <HTML><HEAD></HEAD><BODY><P>I get "There was a failure during processing". Error 999999 &amp; the field is not nullable.</P><P>Some rows do have zero if both fields.</P></BODY></HTML> Mon, 21 Sep 2020 17:40:28 GMT https://community.esri.com/t5/python-questions/calculate-raito/m-p/710541#M55077 CCWeedcontrol 2020-09-21T17:40:28Z Re: Calculate raito https://community.esri.com/t5/python-questions/calculate-raito/m-p/710542#M55078 <HTML><HEAD></HEAD><BODY><P>Try replacing the None in <A href="https://community.esri.com/migrated-users/3420">Joshua Bixby</A>‌'s line of code with 0.</P></BODY></HTML> Mon, 21 Sep 2020 17:54:18 GMT https://community.esri.com/t5/python-questions/calculate-raito/m-p/710542#M55078 RandyBurton 2020-09-21T17:54:18Z Re: Calculate raito https://community.esri.com/t5/python-questions/calculate-raito/m-p/710543#M55079 <HTML><HEAD></HEAD><BODY><P>Not sure why I didn't think of that big give away "field is not nullable."</P></BODY></HTML> Mon, 21 Sep 2020 18:10:11 GMT https://community.esri.com/t5/python-questions/calculate-raito/m-p/710543#M55079 CCWeedcontrol 2020-09-21T18:10:11Z