Can someone please help me, this is very urgent.
I need to create a report that has a formula field in combining a quote number and a quote line but now if i put a sort in it sorts the quote number correctly but not the lines. for e.g if it has more than 10 lines it sorts it as follow
quote1 - 1
quote1 - 10
quote1 - 2
quote1 - 3
and so forth...
what i gathered is that i need to somehow sort 2 characters and not one