Hi community,
I am using a calculated field as filter. This field contains age range (0-10, 11-20 and so on) but in filter it is sorted alphanumerically. I want it in continuation. Is there a possible way to get it done.
Above mentioned is a sample formula,
where I have left one string space after every condition (" 0-10") for the one and two digit ranges but for the three digit range I havenβt left any string space (β100-110β).
Let me know if you need further assistance on this issue.
Not sure if we can achieve exactly how you expect in the filter control. But you can do a bit of work around in your calculation to have the age range in order in your filter control. Instead of 0 - 10, 11-20, 21-30, 31-40, 41-50, 51-60, 61-70, 71-80, 81-90, 91-100 try this numeric format 000 - 010, 011 - 020, 021 - 030, 031 - 040, 041 - 050, 051 - 060, 061 - 070, 071 - 080, 081 - 090, 091 - 100 in your ifelse condition