I am trying to create a field "conflict", and the condition is when other fields in that row have the same maximum number the function returns "Yes". I am having trouble making this work in the field calculator in ArcGIS Pro.This is what my attribute table looks like and the error I get (see pictures below).
I eventually want to see which fields(Koala, GHFF, Education, Cropping, Conservation, Cattle, and Carbon) have the same value as the "Max value" field, then use the conflict field to indicate if there is more than 1 field with the same value as the maximum value.
I'm fairly new to coding.
def conflict (Ed,Con,max):
if max in (Con and Ed):
return ("Yes")
else:
return ("No")
conflict(!Education!,!Conservation!,!MaxValue!)