topic Tabulate Intersection Does Not Sum Fields Correctly in Geoprocessing Questions https://community.esri.com/t5/geoprocessing-questions/tabulate-intersection-does-not-sum-fields/m-p/1266177#M26755 <P>I am using ArcGIS Pro 3.0. I am simply trying to sum the square footage from a point parcel file (4 columns representing different land uses) by census blocks. The tool seems to only report the total square footage from one of the columns (seemingly at random). Often times even if there is square footage in a zone that is not reflected in the total. Someone else reported similar behavior from a previous version of Pro. This seems to be a bug when summing integer columns from a point feature class by polygon zones.&nbsp;</P> Thu, 09 Mar 2023 20:33:24 GMT RussellProvost1 2023-03-09T20:33:24Z Tabulate Intersection Does Not Sum Fields Correctly https://community.esri.com/t5/geoprocessing-questions/tabulate-intersection-does-not-sum-fields/m-p/1266177#M26755 <P>I am using ArcGIS Pro 3.0. I am simply trying to sum the square footage from a point parcel file (4 columns representing different land uses) by census blocks. The tool seems to only report the total square footage from one of the columns (seemingly at random). Often times even if there is square footage in a zone that is not reflected in the total. Someone else reported similar behavior from a previous version of Pro. This seems to be a bug when summing integer columns from a point feature class by polygon zones.&nbsp;</P> Thu, 09 Mar 2023 20:33:24 GMT https://community.esri.com/t5/geoprocessing-questions/tabulate-intersection-does-not-sum-fields/m-p/1266177#M26755 RussellProvost1 2023-03-09T20:33:24Z Re: Tabulate Intersection Does Not Sum Fields Correctly https://community.esri.com/t5/geoprocessing-questions/tabulate-intersection-does-not-sum-fields/m-p/1266188#M26757 <P>Well it appears NULL values throw the tool for a loop. If the tool encounters a null value for a particular field first when joining, the summation process stops. Unreal. Banged my head against the wall all day.&nbsp;</P> Thu, 09 Mar 2023 20:44:35 GMT https://community.esri.com/t5/geoprocessing-questions/tabulate-intersection-does-not-sum-fields/m-p/1266188#M26757 RussellProvost1 2023-03-09T20:44:35Z