Lets say i have a feature class or table with 3 fields
[val1], [val2], [val3]
all are floating point fields.
i add a new field
and I want to use Field Calculate to get
[mean] = AVERAGE([val1], [val2], [val3])
how do i do that? I have tried AVERAGE, AVG, MEAN, I have tried looking for help on this. Usually, VBA commands as used in Excel or Access work fine in field calculator, but AVERAGE does not work.
I dont care if its python or VBA, I just need something that works in Field Calculate.
I have no null values in any of the 3 fields I am trying to average.
NOTE: I am NOT trying to find the average of values in a field (vertical) - right clicking the field name and selecting statistics will not do what i need, nor will the Summary Statistics tool.