MichaelGraham2
8 years agoQrew Assistant Captain
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] < 100000, "0 - 100,000",
[Price] >= 100000 and [Price]< 200000, "100,000 - 200,000",
[Price] >= 200000 and [Price]< 300000, "200,000 - 300,000",
[Price] >= 300000 and [Price]< 400000, "300,000 - 400,000",
[Price] >= 400000 and [Price]< 500000, "400,000 - 500,000",
[Price] >= 500000 and [Price]< 600000, "500,000 - 600,000",
[Price] >= 600000 and [Price]< 700000, "600,000 - 700,000",
[Price] >= 700000 and [Price]< 800000, "700,000 - 800,000",
[Price] >= 800000 and [Price]< 900000, "800,000 - 900,000",
[Price] >= 900000 and [Price]< 1000000, "900,000 - 1,000,000",
[Price] >= 1000000 and [Price]< 2000000, "1,000,000 - 2,000,000",
[Price] >= 2000000 and [Price]< 3000000, "2,000,000 - 3,000,000",
[Price] >= 3000000 and [Price]< 4000000, "3,000,000 - 4,000,000",
[Price] >= 4000000 and [Price]< 5000000, "4,00,000 - 5,000,000",
[Price] > 5000000, "Over 5,000,000")
It sorts, by 0, then 1,000,000 and then 100,000?
If([Price] < 100000, "0 - 100,000",
[Price] >= 100000 and [Price]< 200000, "100,000 - 200,000",
[Price] >= 200000 and [Price]< 300000, "200,000 - 300,000",
[Price] >= 300000 and [Price]< 400000, "300,000 - 400,000",
[Price] >= 400000 and [Price]< 500000, "400,000 - 500,000",
[Price] >= 500000 and [Price]< 600000, "500,000 - 600,000",
[Price] >= 600000 and [Price]< 700000, "600,000 - 700,000",
[Price] >= 700000 and [Price]< 800000, "700,000 - 800,000",
[Price] >= 800000 and [Price]< 900000, "800,000 - 900,000",
[Price] >= 900000 and [Price]< 1000000, "900,000 - 1,000,000",
[Price] >= 1000000 and [Price]< 2000000, "1,000,000 - 2,000,000",
[Price] >= 2000000 and [Price]< 3000000, "2,000,000 - 3,000,000",
[Price] >= 3000000 and [Price]< 4000000, "3,000,000 - 4,000,000",
[Price] >= 4000000 and [Price]< 5000000, "4,00,000 - 5,000,000",
[Price] > 5000000, "Over 5,000,000")