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!

Finde mehr Beiträge mit dem Tag

Accepted answers

All comments

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.

FrankWakeley

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

AbdullahAnter

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

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.

WesMiller

Nimm an der Diskussion teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

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