Calculating field values only for appropriate features using ArcMap

RafaelMichael

Just like in the attached picture. I would like to calculate the value for the field "indeks_star" with the formula: indeks_star =[TOT_65__] / [TOT_0_14] * 100

And for features where in the field TOT_0_14 occurs 0 or in [TOT_65__] occurs 0, I would like the value -9999 to appear in the field indeks_star.

What formula to enter in the field calculator to simultaneously calculate all values for the field indeks_star?

DavidPike

Hello again,

on field calculator, select Python as your parser (top radio button) and select 'show codeblock' which appears in the middle of the window.

where it has whitespace below 'pre-logic script code' insert the code below

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">percentage</SPAN><SPAN class="punctuation token">(</SPAN>field1<SPAN class="punctuation token">,</SPAN> field2<SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">:</SPAN>

    <SPAN class="keyword token">if</SPAN> field1 <SPAN class="operator token">!=</SPAN> <SPAN class="number token">0</SPAN> <SPAN class="operator token">and</SPAN> field2 <SPAN class="operator token">!=</SPAN> <SPAN class="number token">0</SPAN> <SPAN class="punctuation token">:</SPAN>
        <SPAN class="keyword token">return</SPAN> <SPAN class="punctuation token">(</SPAN> <SPAN class="punctuation token">(</SPAN>float<SPAN class="punctuation token">(</SPAN>field1<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">/</SPAN> float<SPAN class="punctuation token">(</SPAN>field2<SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">*</SPAN> <SPAN class="number token">100.0</SPAN><SPAN class="punctuation token">)</SPAN>

    <SPAN class="keyword token">else</SPAN> <SPAN class="punctuation token">:</SPAN>
        <SPAN class="keyword token">return</SPAN> <SPAN class="operator token">-</SPAN><SPAN class="number token">9999</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

in the bottom bit of whitespace it should have something like 'indeks_star =' above it in the greyed out area.  in the whitespace type out this:

percentage(!TOT_0_14!, !TOT_65!)