The average value is incorrect in the Summary table for Insights for ArcGIS compared to the true average value.
上次发布: November 21, 2018ArcGIS Insights
漏洞 ID 编号
BUG-000118095
已提交
November 9, 2018
上次修改时间
June 5, 2024
适用范围
ArcGIS Insights
找到的版本
N/A
操作系统
N/A
操作系统版本
N/A
状态
Will Not Be Addressed
开发团队已考虑过该问题或请求,并决定不会解决该问题。 问题的“其他信息”部分可能包含进一步说明。
附加信息
The difference is due to differences in data precision.
I have used a number of different methods to find the average, each of which use different precisions:
EXCEL 87.31481481
SQL (ACCESS) 86.7407407407407 NUMBER (DOUBLE)
ArcGIS 86.74074074 DOUBLE
Python 86.8260869565652173 FLOAT
Insights also uses NUMBER with 8 decimal places so the answer is the same as ACCESS and ArcGIS Pro (86.7407).