HI team ,
I need to sort 2 cols. (both name and month are to be sorted in descending) and I am stuck in a workflow using sorting tool. Appreciate if you can help. Tried the sort tool but only the first col . is sorted correctly.
Name | Month | Salary |
a | jul | 1 |
b | dec | 2 |
a | jan | 3 |
b | sep | 4 |
expected output:
Name | Month | Salary |
b | dec | 2 |
b | sep | 4 |
a | jul | 1 |
a | jan | 3 |
Solved! Go to Solution.
Hi Emil
Thanks for the reply.
The columns which I have are kind of dummy cols ...
In the actual data set I have 2 cols. with data type as Double. but it didn't work out.
Col. Avg RW is already sorted, but SUM RWA GBP is not .
Avg_AVERAGE RW | Sum_EAD GBP | Sum_RWA GBP |
12.5 | 0.87568 | 10.95 |
12.5 | 21749.89 | 271,873.66 |
12.5 | 74.90395 | 936.30 |
12.5 | 9.864941 | 123.31 |
Are you sure they are duble? I needed to remove the , sign in order to change the data type correctly:
I have used this formula to make it work:
Replace([ Sum_RWA GBP ], ',', '')
thanks emil..
It worked.