I have a very simple detail document in RS that one of my customers is trying to export into excel then sort by a column that in RS is a percentage and it is not sorting. We have tried to modify the data type of the field in Excel, but it is looking at the absolute value of the number and not paying attention to the decimal. for example it is sorting desc as follows:
| -97.90 % |
| 97.18 % |
| 93.70 % |
| -93.28 % |
| -92.20 % |
| 92.07 % |
| -91,698.00 % |
| 90.48 % |
- any ideas?
Thanks -
Angi