sorting where unknown should be at the end

[LinPro]

Hi

I am trying to do a sort on a character field. However in the column there are unknowns - the client wants to put all unknowns at the end of the sort list. What special character can I use to do this?

Lin

 

[bdreed35]

What do you mean by unknowns? Is it the actual text "Unknown" or is it a blank or null value?

You could create a formula to group on and then just display the actual field on the report.

If UPPER({table.field}) = "UNKNOWN" then
    "ZZZZZ" + {table.field}
else
    {table.field}

Then you can sort on this field, but still just continue to display {table.field} on the report.



~Brian

 

[LinPro]

thanks Brian

I have already figured out what to do.

Lin