topic Re: Need to calculate values for multiple records with a commond ID # ArcPY in Python Questions https://community.esri.com/t5/python-questions/need-to-calculate-values-for-multiple-records-with/m-p/21290#M1623 <HTML><HEAD></HEAD><BODY><SPAN>Yes, but I'm not sure if I see where that option exists?</SPAN></BODY></HTML> Tue, 11 Mar 2014 18:34:31 GMT AndrewTuleya1 2014-03-11T18:34:31Z Need to calculate values for multiple records with a commond ID # ArcPY https://community.esri.com/t5/python-questions/need-to-calculate-values-for-multiple-records-with/m-p/21288#M1621 <HTML><HEAD></HEAD><BODY><SPAN>I have a table "Projects" with multiple project ID's and multiple records per project ID. I want to take the sum of values in multiple fields and combine them based on project ID. For example Project A might have 3 records with varying data between records for a field called "Labor_Hours". I want to get the sum of Labor_Hours for all records with a project ID or "Project A" by using Arcpy. I could use the field calculator to only calulate values for Project A, however I will have varying project IDs when importing new records every week. </SPAN><BR /><BR /><SPAN>In summary, i want my Arcpy script to run calculations for a set of records with the same Project ID Any suggestions?</SPAN></BODY></HTML> Tue, 11 Mar 2014 16:15:18 GMT https://community.esri.com/t5/python-questions/need-to-calculate-values-for-multiple-records-with/m-p/21288#M1621 AndrewTuleya1 2014-03-11T16:15:18Z Re: Need to calculate values for multiple records with a commond ID # ArcPY https://community.esri.com/t5/python-questions/need-to-calculate-values-for-multiple-records-with/m-p/21289#M1622 <HTML><HEAD></HEAD><BODY><SPAN>Thanks! The summary statistics tool is exactly what I am looking for!</SPAN></BODY></HTML> Tue, 11 Mar 2014 16:42:26 GMT https://community.esri.com/t5/python-questions/need-to-calculate-values-for-multiple-records-with/m-p/21289#M1622 AndrewTuleya1 2014-03-11T16:42:26Z Re: Need to calculate values for multiple records with a commond ID # ArcPY https://community.esri.com/t5/python-questions/need-to-calculate-values-for-multiple-records-with/m-p/21290#M1623 <HTML><HEAD></HEAD><BODY><SPAN>Yes, but I'm not sure if I see where that option exists?</SPAN></BODY></HTML> Tue, 11 Mar 2014 18:34:31 GMT https://community.esri.com/t5/python-questions/need-to-calculate-values-for-multiple-records-with/m-p/21290#M1623 AndrewTuleya1 2014-03-11T18:34:31Z Re: Need to calculate values for multiple records with a commond ID # ArcPY https://community.esri.com/t5/python-questions/need-to-calculate-values-for-multiple-records-with/m-p/21291#M1624 <HTML><HEAD></HEAD><BODY><SPAN>Ok I believe I did it. </SPAN><BR /><SPAN>Thanks</SPAN></BODY></HTML> Tue, 11 Mar 2014 18:57:32 GMT https://community.esri.com/t5/python-questions/need-to-calculate-values-for-multiple-records-with/m-p/21291#M1624 AndrewTuleya1 2014-03-11T18:57:32Z