Spatial Join Merge rule (mean, median, mode, sum) are missing from the list.

Question

Hello, I have been trying to use a spatial join with the "mean" or "median" merge rules, but I cannot find them in the merge rule list. I can only use (first, last, mode, min, max, and count). I am using ArcGIS Pro 2.9 through my organization. Is this problem related to the file type I am using (shapefiles, raster, or point)?

Please help!

DanPatterson · Accepted Answer

is the field you have selected (STATEEFP ) text or numeric?

The merge rules change depending on the field data type