Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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,
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,
Hi,
eg use this as expression:
if(ProductCode<4, ProductCode,'4+')
Greetings,
Piet