AnsweredAssumed Answered

Select highest numbers and divide by 2

Question asked by benitosalinas on Jun 27, 2012
Latest reply on Jun 27, 2012 by philmodjunk


Select highest numbers and divide by 2


 I have 5 different number fields.  I need to select the two fields with the highest two numbers, add those two highest numbers and divide the sum by 2 to get an average.  I need that average to go to a different emply field. Please help my knowledge of FM is limited.

Please help

 I did not mention that each one of the five numbers is the sum of 4 numbers in different fields.  I need to add the two highest sums and divide them by two.  Sorry I was not clear on this.  Can you help me?