topic Re: Using Python in Field Calculator in Geoprocessing Questions

Using Python in Field Calculator

BrianElliott — Thu, 23 Sep 2010 16:46:23 GMT

How can I get this simple code to work using python in the field calculator? I cannot get the syntax correct to save my life.

if (!Shape_Area! / 2000) - (math.trunc (!Shape_Area! / 2000) + 1) = 0:
EQ = (!Shape_Area! / 2000) * 30
else:
EQ = (truncate ((!Shape_Area! / 2000) + 1) * 30

I can't get passed the first line without a syntax error.

I would love any help on this,
thanks

Re: Using Python in Field Calculator

BrianElliott — Thu, 23 Sep 2010 17:17:22 GMT

I did not copy all of the code correctly. Still cannot get passed first line of code...

if (!Shape_Area! / 2000) - math.trunc((!Shape_Area! / 2000) + 1) == 0:
EQ = (!Shape_Area! / 2000) * 30
else:
EQ = math.trunc((!Shape_Area! / 2000) + 1) * 30

Re: Using Python in Field Calculator

GerryGabrisch — Thu, 23 Sep 2010 17:33:41 GMT

Assuming the indentations are correct, you don't use the ! in the code itself, and you need == not =.
See the link below.
Good luck

if (Shape_Area / 2000) - (math.trunc (Shape_Area / 2000) + 1) == 0:

www.esri.com/news/arcuser/0507/files/pythonscript.pdf

Re: Using Python in Field Calculator

DanPatterson_Retired — Thu, 23 Sep 2010 17:51:33 GMT

tested on a shapefile not a geodatabase

Re: Using Python in Field Calculator

BrianElliott — Thu, 23 Sep 2010 18:37:42 GMT

THANKS DAN!!!

I need to learn more about python, obviously. Your code worked perfectly.
Now I can go get a beer. 🙂

Re: Using Python in Field Calculator

DanPatterson_Retired — Thu, 23 Sep 2010 22:05:42 GMT

pass one through the screen