Hey all I'm creating a spatial join with apartments in a city and census blocks. In the apartment attribute table there's a field containing number of beds per apartment. The reason for the spatial join is to see the density of beds to population per census block. My problem is when i go ahead and join the two shapefiles, for every apartment complex I get the population count for EVERY apartment complex. I want to be able to see the total number of beds per block so that i get a more accurate density. I've tried the Merge rule sum for the number of beds attribute, but it doesn't seem to be working. Is there any other merge rule I could use?
If you need more clarification please don't hesitate to ask