Group Number

[SP3000]

Hi,

I am trying to group the number column into group columns as mentioned in the below table. Can someone please advise the best way to do it?

Number	Group	Group2
34037	30000-40000	30K - 40K
66299	60000-70000	60K - 70K
50413	50000-60000	50K-60K
31672	30000-40000	30K - 40K

[Christina_H]

If all your groups are equal sizes, I would use something like this:

tostring(floor([Number]/10000)*10000)+"-"+tostring(ceil([Number]/10000)*10000)

This gives you the first group, or you can edit it for the second format.

[afv2688 · Accepted solution]

Hello @SP3000 ,

How about this

ToString(Round([Number]-5000, 10000)) + '-' +
ToString(Round([Number]+5000, 10000))

AND

ToString(Round([Number]-5000, 10000)/1000) + 'K - ' +
ToString(Round([Number]+5000, 10000)/1000) + 'K'

Regards

[SP3000]

Thank you so much!

[SP3000]

Thank you so much!