Out of three different fields find the nearest value of X

[المشرف العام]

I have 4 Fields.

FFE,year10,year50,year100

I created a 5th field and labeled it - CP

I need help writing a python script in field calculator to fill the column CP with whatever FFE is closest to out of year10, year50, year100.

Example:

FFE = 45

year10 = 35

year50 = 51

year100 = 60

Desired result would be - CP = year50



أكثر...