I have a field that represents apartment number and it is string. When I have a group sorted by that field, I get:
1
11
12
2
etc..
I want it to go is it would if it were a number..
1
2...etc
I have tried to create a sort formula:
if isnumeric({table.field}) then ToNumber({table.field}) else -1
But that is not working..
I mean it is working, but the numbers are like this:
1,00
2,00..
Can someone help? I tried to put ToText, but then it gives me an error
Member
9 Points
38 Posts
How to sort group by number if the field is string?
Mar 19, 2018 07:26 PM|tricman10|LINK
I have a field that represents apartment number and it is string. When I have a group sorted by that field, I get:
1
11
12
2
etc..
I want it to go is it would if it were a number..
1
2...etc
I have tried to create a sort formula:
But that is not working..
I mean it is working, but the numbers are like this:
1,00
2,00..
Can someone help? I tried to put ToText, but then it gives me an error
Contributor
2842 Points
767 Posts
Re: How to sort group by number if the field is string?
Mar 26, 2018 11:30 AM|mshoaiblibra|LINK
As per your question can you try following code:
M Shoaib Waheed
MCSD & MCPD [Web Development 4.0]
http://shoaib.pk