How to sort group by number if the field is string? [Answered]RSS

• • Reply
  tricman10

  Member

  8 Points

  37 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:

  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

• • Reply
  mshoaiblibra

  Contributor

  2832 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:

  If NumericText ({table.field}) Then
        ToNumber ({table.field})
  Else
       -1;

  Please mark the replies as if they help or unmark if not.
  
  M Shoaib Waheed
  MCSD & MCPD [Web Development 4.0]
  http://shoaib.pk