All, First time posting and I have searched for this issue but didn't find where it was previously addressed. I have added a field call "Loans" and it contains hundreds or thousands of numbers including zeros and decimals. I also have a new field called LoanScore Compute the mean of Loans and if the item on that row is above the mean assign a "1" to that row in LoanScore. I am running ArcGIS 10.3.1 and Python 10.3.1 on 64 bit Windows. Previously, I was able to run this in excel using the statement =if(median(a$2:a$1000)<a2,1,0) and then just filled the whole LoanScore column with that formula [where a2 was the first number in the "Loans" column] Thank you for any assistance.
... View more