I'm working from a geodatabase in ArcMap 10.5, and using Model Builder.
I currently have a field with values that range from 0 to 30 and I want to convert that to a 0-10 scale. The idea was to use a formula like:
([VALUE]/[MAX VALUE])*10
Which, after some minor research, I assumed would be something like this in Field Calculator (using...):
(INDEX/max(INDEX))*10
But it doesn't work. The calculator does not return any error, it just doesn't give the exepected results. I tried adding [] to the max function, adding some extra fields so i has something else to search on, etc, but I always get one of these results:
- All with value = 1 and some NULLs (which is odd 'casue there are no initial NULL values)
- All with value = 10 and some NULLs (same as above in this case)
Any of these makes sense taking the formula in mind, but there is also no error message, so I assume there is some piece I am missing to make the calculation work correctly.
How can I (if it's even possible) get the max value in a field to calculate this formula?
Doesn't matter if it's VB Script or Python (currently using the latter) or even if it's some workaround, as long as it works.
float(index)/float(max(index))
This is due to the fact that in the old python 2.7, if I am not wrong, the ratio operator returns the same type of the input.