SQL expression to sum cells in the same field

ShikoNjuno — Thu, 11 Jul 2013 17:14:53 GMT

Does anyone have any expression or code they can offer that I could incorporate into my Calculate Value Tool on Model Builder?
What I'm trying to do is add multiple cells of a given attribute field and output that value as a sum.
Thanks.

Shiko

Re: SQL expression to sum cells in the same field

ShitijMehta — Mon, 15 Jul 2013 17:33:37 GMT

Hi Shiko,

Try this:

Create a model: - Use a selection tool like make feature layer/ Select a layer By attribute/Select to select the records and then pass the output selection to the Summary Statistic Tool : Summing the field you want to for the selected records > then use the Get Field Value tool (Only works in ModelBuilder) to get the sum value from the statistic table. You can then use this sum value in the tool you want. You can make the output of the summary statistic tool in_memory so that you don't have to save an extra dbf table.

Hope this helps.

topic Re: SQL expression to sum cells in the same field in Geoprocessing Questions

SQL expression to sum cells in the same field

Re: SQL expression to sum cells in the same field