nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Calculate raito

CCWeedcontrol

I need to calculate ratio between two numbers than to percent but some rows in both field1 and field2 have zero values.

Simple calculator field2 / field1 * 100 but field1 has zeros, how do I by pass the rows with zeros in field1 in field calculator?

Field 1 field 2

0 15200 --> can't divide 0/15200

Trouver plus de publications taguées avec

Accepted answers

JoshuaBixby

Put the following in the expression box using a Python parser:

!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>

All comments

CCWeedcontrol

Not sure why I didn't think of that big give away "field is not nullable."

RandyBurton

Try replacing the None in Joshua Bixby‌'s line of code with 0.

CCWeedcontrol

I get "There was a failure during processing". Error 999999 & the field is not nullable.

Some rows do have zero if both fields.

CCWeedcontrol

Ya I could have done it that way but I want to know who to do it through field calculator.

JoshuaBixby

Put the following in the expression box using a Python parser:

!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>

JoeBorgione

Are you doing this in python or just the field calculator? Either way, select out those records that meet your criteria then apply the calculation.

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.