Sorting Data in Text Box

[#1]

Hi Guys,

I am trying to list the values of a dimension in a text box, using concat funtion, I am successfully able to list them out by using the following function  but the problem is since my dimension also has 0 or blank values . it lists out 0 values before listing out the actual text values. Can you guys help ? Thanks ,

=

'

' &Concat([Field Name1], '

',)

End goal is to have the blank values show up below the text values.

just additional info in case this might help, Field Name 1 which has mostly text values and some blank/0 values , is linked to another Field Name2 that contains numberic values 15,16,17 .

Thanks,

[sunny_talwar]

Try this may be:

=Concat([Field Name1], Chr(13), Match(Trim([Field Name1]), '*', ' '))

[maxgro]

=Concat(if(len(trim(field))>0,field), '-', -field) & '-' &Concat(if(len(trim(field))=0,field), '-', -field)