I have calculated column in a document library. The value for this column is a part of the files title. I'm using this formula:
The data type returned from this formula is currency (I tried number as well) with zero decimal places. It all works fine except when it comes to sorting the list based on my calculated column. I'm sorting in descending order. First the list sorts itself by five digit numbers from largest to smallest. Then the list sorts itself by six digit numbers by largest to smallest. Ex: $96,000 $92,000 $90,000 $250,000 $220,000 $200,000 etc. How can I get it to sort properly?
Ascending order takes the six digit numbers first and sorts them from smallest to largest, then it takes the five digit numbers and does the same.