class() function

Anonymous — Mon, 22 May 2017 02:24:27 GMT

Hi all,

I want to display a dimension of income using the class() function.

dimensions are as follows:

0=<x<1000

1000=<x<2000

2000=<x<3000

3000=<x<4000

4000=<x<5000

5000=<x<6000

6000=<x<7000

7000=<x<8000

8000=<x<9000

9000=<x<10000

10000=<x<15000

15000=<x<20000

x => 20000

i am able to obtain all the intervals using :

=if(HOUSEHOLDINCOME>10000,

class(HOUSEHOLDINCOME,5000),

class(HOUSEHOLDINCOME,1000))

Having trouble with the last range of x=>20000,

any suggestions would be appreciated.

Regards,

Gaston

Re: class() function

tresB — Mon, 22 May 2017 06:17:58 GMT

Try just putting one more condition like:

= If(HOUSEHOLDINCOME>=20000, 'x => 20000',

if(HOUSEHOLDINCOME>10000,

class(HOUSEHOLDINCOME,5000),

class(HOUSEHOLDINCOME,1000))

)