Python if statement in arcpy.CalculateField_management isn't working?

MichaelRamm

Hi - I'm having trouble getting an if statement to work and was hoping someone could help?

I need to copy the data from a field called SUM_Green to G, replace any null values in a dataset with 0, so I've used the following, but can't seem to find anything that works:

Any ideas?

Thanks.

JoshuaBixby

I agree with Darren Wiens‌ that using Python Conditional Expressions is the way to go in situations like this.  In case you couldn't rely on SUM_Green being greater than or equal to one, you can explicitly handle NULL by using Python's NoneType:

arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>MULTIs<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"G"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"0 if !SUM_Green! is None else !SUM_Green!"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"PYTHON_9.3"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>