nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Is there a way to get the maximum value of a column in Field Calculator?

FrankWakeley

I want to have a function in my model that converts an arbitrary value to a percentage within that column's range. It would need to be dynamic. Right now I have:

def prob( Failure_Score 😞

my_list = arcpy.da.TableToNumPyArray ("Failure_Score")

my_max = max(my_list)

percentage = (Failure_Score / my_max)*100

return percentage

but it returns nothing. Really any advice would be greatly appreciated.

Thanks!

Find more posts tagged with

Accepted answers

All comments

WesMiller

Hornbydd

The reason why your code above is failing is because you have not entered all the required parameters to the function TableToNumPyArray(). If you read the help file for this function you will see that it takes two parameters Table name and a list of fields, the remaining 3 parameters are optional. The Syntax section of the help file for any function explains the parameter order. You should spend some time getting yourself familiar in reading these documents.

AbdullahAnter

if you put the tools in correctly way, the value will be generate dynamically each iteration.

FrankWakeley

Would I be able to input that value dynamically or would it be manually input each iteration?

AbdullahAnter

You can put Summary Statistics tool and operate this for your field to get maximum value , then you can get this value by using Get Field Value tool , and use this Value in your expression.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.