I need to workout the mean participation value from the data table for the coarser level of governance, what this means is i have multiple values from the finer level that i need to calculate the mean for then link to the coarser level. I've tried using the summary statistics tool on a joined then exported table with casefields but the return seems to be an integer, not a float
Feature layer table, working field is NUTS315CD/NUTS315NM
Link table, Contains NUTS318CD(same codes as the previous table just different naming convention) and finer level of governance codes needed to link to the data table
data table, county is the same as LAD16C from the link table, participation is the data i need to calculate the mean for
merged table that i'm trying to run tools on
Do you have any pointers for tools or scripts?
Solved! Go to Solution.