Vincent
October 30, 2020, 10:05am
1
Hi All,
I have a list of number integer but I’m having some sorting in my BAQ and it appear as following:
Does any know how to make is as sorted display as 1,2,3,4,5,instead of 1,10,11,12,13…
as SQL i understand can be using Order By Key2 + 0 ASC, but I dont know how to formula in BAQ.
Thanks in advance.
LBARKER
October 30, 2020, 10:35am
2
I’m no expert, and I only learnt it this week,… first step is to create a calculated field, field type int, format >>>99 in the expression box type in convert(int, UD02.Key2), and then sort by that field
it only works if what is in key02 is a number
3 Likes
Vincent
October 30, 2020, 10:44am
3
Ah yes, this is what I want, thanks Barker…
LBARKER
October 30, 2020, 10:46am
4
No problems, glad to be of assistance
