https://community.esri.com/t5/data-management-questions/field-calculator-is-taking-long-time-for/m-p/1114003#M43632 <LI-CODE lang="python">from arcpy.da import TableToNumPyArray tbl = r"C:\arcpro_npg\npg\Project_npg\npgeom.gdb\xxxx" flds = ["A", "B"] arr = TableToNumPyArray(tbl, flds, where_clause=None, skip_nulls=True, null_value=None) numerator = arr["A"] * arr["B"] denom = np.sum(arr["B"]) final = np.sum(numerator) / denom final 49.648290039245</LI-CODE> Thu, 04 Nov 2021 12:13:00 GMT DanPatterson 2021-11-04T12:13:00Z https://community.esri.com/t5/data-management-questions/field-calculator-is-taking-long-time-for/m-p/1113980#M43630 <P>Hello all,</P><P>&nbsp;</P><P>Can anyone help me to increase the speed of the field calculator in ArcGIS Pro? I've about 4000000 features. I want to calculate the aggregate average. For that, I've to perform multiplication first and do the summation.&nbsp;</P><P>But the multiplication of two fields is taking more than 24 hours on my computer. My computer is i7 11 generation with ram 32GB.</P><P>Can anyone please suggest how to make this process faster or suggest any other way to calculate aggregate average faster?&nbsp;</P><P>&nbsp;</P><P>Thank you so much.</P><P> The formula for average will be like, where W and D are two fields.&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="scadawatch_analytical_function_wma_formula.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/26805iE2664703F829F856/image-size/medium?v=v2&amp;px=400" role="button" title="scadawatch_analytical_function_wma_formula.png" alt="scadawatch_analytical_function_wma_formula.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Thu, 04 Nov 2021 09:41:52 GMT https://community.esri.com/t5/data-management-questions/field-calculator-is-taking-long-time-for/m-p/1113980#M43630 saidurgamalleswarthota 2021-11-04T09:41:52Z https://community.esri.com/t5/data-management-questions/field-calculator-is-taking-long-time-for/m-p/1113981#M43631 <P>I would can the session and reboot and try again.&nbsp; Nothing should take that long for multiplication.</P><P>If you want speed, work outside the field calculator</P><P><A href="https://pro.arcgis.com/en/pro-app/latest/arcpy/data-access/tabletonumpyarray.htm" target="_blank">TableToNumPyArray—ArcGIS Pro | Documentation</A></P><P>do the multiplication and summation in NumPy if you are python adept</P> Thu, 04 Nov 2021 09:45:19 GMT https://community.esri.com/t5/data-management-questions/field-calculator-is-taking-long-time-for/m-p/1113981#M43631 DanPatterson 2021-11-04T09:45:19Z https://community.esri.com/t5/data-management-questions/field-calculator-is-taking-long-time-for/m-p/1114003#M43632 <LI-CODE lang="python">from arcpy.da import TableToNumPyArray tbl = r"C:\arcpro_npg\npg\Project_npg\npgeom.gdb\xxxx" flds = ["A", "B"] arr = TableToNumPyArray(tbl, flds, where_clause=None, skip_nulls=True, null_value=None) numerator = arr["A"] * arr["B"] denom = np.sum(arr["B"]) final = np.sum(numerator) / denom final 49.648290039245</LI-CODE> Thu, 04 Nov 2021 12:13:00 GMT https://community.esri.com/t5/data-management-questions/field-calculator-is-taking-long-time-for/m-p/1114003#M43632 DanPatterson 2021-11-04T12:13:00Z https://community.esri.com/t5/data-management-questions/field-calculator-is-taking-long-time-for/m-p/1114392#M43635 <P>Thank you for your help. I think I found my mistake. The last time when I did the multiplication the newly created field type was selected as text. Now I chose the type as double and the field calculator is working just fine. all the calculations were under 3-4 minutes. Thanks again.</P> Fri, 05 Nov 2021 04:40:25 GMT https://community.esri.com/t5/data-management-questions/field-calculator-is-taking-long-time-for/m-p/1114392#M43635 saidurgamalleswarthota 2021-11-05T04:40:25Z