2 Replies Latest reply: Jan 25, 2012 5:02 AM by Celambarasan Adhimulam RSS

    grouping values

      Hi I got a field (A) with values going from 1 to 9 (maybe with new data will go over 10) and i need to group them into 3 categories of a new field (B):

      If A=1 then B='1'

      If A=2 then B='2'

      If A>=3 then B='3+'

       

      could you help me in writing the right script to build up the new field?

       

      Thanks in advance