Hi everyone.
I need to transform a list of salary ranges so they appear in descending order and have 'Prefer not to say' at the bottom. I have attached the Excel of the table and it is column 'My current salary is...' that needs transforming.
Is there a way I can transform the column so they appear in the following order:
My current salary is.... |
Over £200,000 |
£180000 - 199,999 |
£160,000 - 179,999 |
£140,000 - 159,999 |
£120,000 - 139,999 |
£100,000 - 119,999 |
Under £20000 |
Prefer not to answer |
Thanks in advance,
KA
Solved! Go to Solution.
Hey @arundaka03,
Here is one way to do this:
My approach was to get the salary as a number (not text) then sort by that. I got the number using regex then use a formula to make it a number.
Any questions or issues please ask
Ira Watt
Technical Consultant
Watt@Bulien.com
i would create a SORT field that is numeric based upon the values. Another approach is to define the values with a leading number. Then at the end of your process use a substring function to skip the number and update the field.
cheers,
mark