Latest Contributions by JoshuaBixby

There is definitely a way to address this without resorting to plugging values in by hand.  That being said, it isn't going to be a simple expression in Field Calculator that does it.  Do you have a requirement to use Field Calculator?  If so, I think "The Web" has already given you the answer(s). The behavior you are seeing, at least the parts that aren't errors, are expected.  Field Calculator operates like a cursor, at least logically.  Field Calculator only sees one record at a time, even if it is operating over an entire set of records.  The Codeblock section allows for a little bit of kung fu but we are talking Kung Fu Panda and not Caine.  This is why your min and max functions are returning VAL instead of the min and max for the field.  If you were looking at minimum or maximum values across fields for a given record, then the approach might work. As Ian Grasshoff‌ mentions, you could use the Summary Statistics tool.  My rub with that tool, and why I seldom use it, is that it creates a table to place the values.  The last thing I want is another table to extract values from and have to clean up afterwards. As Johannes Bierer‌ links to, you could use arcpy.da.TableToNumPyArrary to dump the table and find the minimum, maximum, or other statistics that way.  My only concern with that approach, well all approaches involving lists, is that creating the lists can consume lots of memory depending on the data sets involved.  Why create a list with a million elements if you only want to know the minimum and maximum values for the field. Here is an example of a function you could create and then call from the Python interactive window: def normalizeField(in_table, in_field, out_field):     with arcpy.da.SearchCursor(in_table, in_field) as cur:         x, = next(iter(cur))         minimum = maximum = x         for x, in cur:             if x < minimum:                 minimum = x             if x > maximum:                 maximum = x         with arcpy.da.UpdateCursor(in_table, [in_field, out_field]) as cur:         for x, y in cur:             y = (float(x) - minimum)/(maximum - minimum)             cur.updateRow([x,y]) The float with the UpdateCursor ensures the normalization value doesn't truncate to an integer if the in_field happens to be an integer. ... View more