AnsweredAssumed Answered

Sum of multiple attribute values

Question asked by Lakesrpc on Sep 17, 2019

It seems that this should be simple, but it is proving to be a challenge. I have a layer with 75 communities (rows). Fifty attributes (columns) were created, each representing a service representing a service that is or is not available in the community, represented by "1" or "0".

 

I want to show the number of services available in each town. I created a new attribute "Services" and expected to use the Field Calculator to total up the value (number of services available) for each row. It appears that the only way I might do that is by typing in Sum([   ]) and typing in the name of all fifty attributes inside the brackets (see below).

 

What am I missing? Is there a simpler way? I don't want a table, I just want a total so that I a broad map showing the number of services available in each community can be shown.

 

Thanks,

Dave

Outcomes