get value with field calculator

Discussion created by Leuzinger on Apr 17, 2012
Latest reply on Apr 18, 2012 by Leuzinger

I have an attributtable with over 20 fields. These fields are filled with short integer values between 1 and 4. In a new field i want to calculate the "best value" out of all fields. Very easy up to now but there is one more condition and this is: the order of the values is 4-1-2-3 (4 is lowest and 3 is best value). I anyone out there could help me with this problem i would be very thankful!!!
Best regards James