calculate sum in an attribute field

Discussion created by jeremytibbetts on Mar 10, 2011
Latest reply on Jul 25, 2012 by athena.nc

Like • Show 0 Likes0
Comment • 5

Hi,
I have a feature class which contain property information, what I would like to do it total the value of all properties and display that in a table. The attribute table looks something like this:
ObjectId     PID     Value
0              1000    10,000
1              1001    25,000
2              1002   100,000 and so on...

I would like to some the value field, in order to give me a total for the entire area. So in this example, the value of all properties would be $135,000... I would like to calculate this and display it...

sounds like a pretty straight forward problem, but I can't seem to find a solution...

Thanks

Outcomes

5 Replies

recurvata Mar 10, 2011 7:33 AM
Easiest way is to open the attribute table, right click the Value field, select Statistics, and a dialog box will pop up with, among other things, the Sum for that field.
3 people found this helpful
Like • Show 0 Likes0
Actions
calebben Mar 10, 2011 7:58 AM
I have this same question. I understand that I can look up the statistics for a certain field. However, is there a way to export this SUM of a field into a new field or table to include in a layout? I can always manually include the SUM (in my case the total number of acres in a field) as text in a layout. But, we process many of these fields and it would be very helpful to automate the process. Can someone please help with this?

Or, is there a way to create a new field with a code equation that I can include in the Field Calculator that will add each individual record (sum) of a specified field so I can include that as a legend item?

Thanks,
Caleb
Like • Show 0 Likes0
Actions
jeremytibbetts Mar 10, 2011 8:29 AM
There is a summary statistics tool, which can be put into a model, which will create a table automatically. I ran this tool in my model and it works well.

Is there anyway of appending to this table which is created?
Like • Show 0 Likes0
Actions
recurvata Mar 10, 2011 9:25 AM
You should be able to join the Sum table back to the original table.
This isn't really good design, however, since the Sum field will be the same for every record, i.e. every value for Sum_Value will be the same. This is a redundancy in the table.
Like • Show 0 Likes0
Actions
athena.nc Jul 25, 2012 7:18 PM
hi, has anyone found the solution to the problem? I have the same problem for some time now and don't seem to find a solution to it.. other than manually count using summary statistics and frequency, which then the result will be exported to a redundant table which I don't really need... Why can't it autmatically do so and display result on layout?

Appreciate if anyone could shed some light on this issue. Thanks.
Like • Show 0 Likes0
Actions

GeoNet

The Esri Community

calculate sum in an attribute field

Outcomes

Related Content

Recommended Content