2 Replies Latest reply: Apr 7, 2011 9:53 AM by Steve Free RSS

    Return field with highest value

      Thanks in advance for any replies.

      I have a load which includes the fields below, indicating how old the record is in days and the value - so only one of these 5 fields can be populated with a value > '£0':

       

      EXAMPLE
      [0-30] - £0
      [31-60] - £800
      [61-90] - £0
      [91-120] - £0
      [>120] - £0

      This means that the record is 31-60 days old with a value of £800
      What I need is a function or code to recognise which of the 5 fields has the value > '£0'
      rangemax returns the highest value of £800 which is ok but need to recognise which of the 5 fields this value is in.