populate a field in a raster dataset based on the total SUM of another field

Discussion created by tdilan1980 on May 3, 2011
Latest reply on Jul 18, 2011 by nilakash
I have multiple land-use land-cover raster layers, of which the attribute tables have a field on the total area coverage by different land-use type (field name is AREA). My goal is to have another column populated with the percentage area coverage for the each land-use land cover type in the rate dataset.
I tried to do this by populating another column in the same attribute table with the summation (total summation, not cumulative summation) of AREA. If I could get this column, I can write a simple expression in the "calculate field tool" to calculate the percentage coverage.
I have nearly 100 raster layers with different geometric shapes so that I need to do this via model builder. Since this is an iterative process, calculating the column sum by the "calculate statistics tool" in not useful either.
Does anyone have a tool or a python script for this? I am using ArcGIS 10.