grouping numeric values

[#1]

Hi,

I have a field on a table which takes numeric values which can range from 1 through to , lets say, 97 although the upper value can be any number

I want to be able to write, ? a mapping, ? which will group these numbers as

Number Group

1 1

2 2

3 3

4 4+

5 4+

etc

but it must be able to capture all possible number from 4 up to the highest number into the 4+ group.

Any ideas?

Thanks

[vgutkovsky · Accepted solution]

I would recommend using a simple IF statement since your group# = your number. It would look like this:

if(number<4,number,'4+') as Group;

Regards,

[#3]

Hi,

eg use this as expression:

if(ProductCode<4, ProductCode,'4+')

Greetings,

Piet