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

    group values


      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