Forcing numbers to sort properly
When given $20,000, $2,000 and $20, Gravity Forms will sort the array like this: $2,000, $20, $20,000 because Gravity Forms is alphabetically sorting the numbers rather than sorting by value. The numbers 1, 2, 5, 10, 30 will be sorted as 1, 10, 2, 30, 5.
This is a known issue with Gravity Forms. We've reported the issue, and rocketgenius hope to include the fix in Gravity Forms Version 2.0.
Until the day the issue is fixed by Gravity Forms, here's how to solve the sorting issue using GravityView.
Add a number field to the Gravity Forms form
Check the "Enable Calculation" box
Enter a calculation that will result in a fraction
The key is to have the absolute largest number result in a calculation of less than 10. Anything up to 9.99999 will work.
It's perhaps cleanest to divide by the largest number, or by a factor of ten.
If you have numbers up to 1000, you could divide by 1000. If you have numbers up to 300, you could divide by 300. If you have a rating scale of 1-10, you could divide by 10 so that your rating scale becomes .1 to 1.
Update the Form
Edit the View you want sorted
Go back to the View you were working on.
Optional: Add the Field to your View
If you want to display the value on your View, you can add the field.
Update the Sort by Field value
Use the new Calculation field as the "Sort by Field" value.