AnsweredAssumed Answered

Field calculator, sum of field.

Question asked by bem08c on Jan 7, 2015
Latest reply on Feb 12, 2015 by deedug

I am having a bit of a problem with what seems like should be a simple field calculator expression. I have a table with about 50 rows and a column with acres for each row. I've created a new column called Percent_Acres (Double) and im looking to calculate the percent each feature makes up of the total acres.

 

I want an expression equal to this Percent_Acres = Acres / Total Acres.

 

Normally this would be easy to do and i would just look up the field statistics for the sum. However this calculation is part of a model that will be automated so i need an expression that will automatically calculate the columns sum while in the field calculator.

 

It appears that i am having a problem with iterating through each row to add up to the total. I have tried numerous expressions and each time i get the same result telling me that "typeerror float object is not iterable"
"

 

 

Any advise on this topic would be greatly appreciated

 

Thanks, Ben

Outcomes