Formula Text field sorting in Dynamic Search
I have this Formula Text field to search on a range of prices, but it sorts numerically and I can't see how I can influence it. It sorts, by 0, then 1,000,000 and then 100,000? If([Price] < 1000...
Forum Discussion
Spaces sort before numbers and two spaces sort before one space. So you will have to contrive your results to have leading spaces for the results that you want to sort higher up in the sequence.