1 Reply Latest reply on Aug 22, 2017 4:23 PM by Shinichiro Murakami

    Bins Issue - Inclusive Bins

    John Neelamkavil

      Hello, I am trying to create Age Bins.

       

      What I can do:

       

      Under 21,

      21-32,

      33-42,

      42+

       

      Using the following:

       

      IF

      [Age] < 21 THEN 'Under 21'

      ELSEIF

      [Age] <= 32 THEN '21-32'

      ELSEIF

      [Age] <= 42 THEN '33-42'

      ELSE '42+'

      END

       

      What I am trying to do:

       

      Under 21,

      Under 32,

      Under 42,

      All

       

      Any ideas how I can do that?

       

      Thanks

      Ankur