Using Python in Field Calculator

[BrianElliott]

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

[BrianElliott]

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

[GerryGabrisch]

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

[DanPatterson_Retired · Accepted solution]

tested on a shapefile not a geodatabase

[BrianElliott]

THANKS DAN!!!

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

[DanPatterson_Retired]

pass one through the screen