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.
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.