2 Replies Latest reply: Jul 7, 2014 4:13 AM by Erik Furlanis RSS

    how to classify values into dynamic groups

      I need to classify values of a field into four classes.

      Depending on the values in a second field, the threshold for the classes are different.

       

      For example.

      if field2=A

      0-10: Null

      11-20: Low

      21-40: Mid

      41+: High

       

      if field2=B

      0-7: Null

      8-17: Low

      18-43: Mid

      44+: High

       

      etc.

       

      in field2 I have at least 10 different values

       

      How can I sort this out, without creating a (roughly) forty-times-nested if statement?

      thanks!