2 Replies Latest reply: Jan 3, 2012 2:57 AM by Sokkorn Cheav RSS

    group values

      Hi,

      I need to group values into a new filed to summarize them.

       

      I was thinking about using function IF

       

      the aim is to have

       

      FIELD A= 1 or 2 or 3   FIELD B= 100

      FIELD B= 4 or 5 or 6   FIELD B= 200

      FIELD C= 7 or 8 or 9   FIELD B= 300

       

      and sons...

      I tried with this script but it seems to reach just the first input of each class

       

       

      If (FIELD A='1' or '2' or '3', '100', If (FIELD A='4' or '5' or '6', '200', If (FIELD A='7' or '8' or '9', '300','N/A'))) as "FIELD B"

       

      I suppose something is missing in the syntax but I don't know what!

       

      thanks in advance