I have the following formula as @Analyst
if isnull({call_req.assignee}) OR {call_req.assignee} = ""
then "UNASSIGNED"
else {ca_contact_1.first_name} + " " + {ca_contact_1.last_name}
The problem is that if there is not a first and last name, it restricts the record return, even though I have told it to display UNASSIGNED. can someone explain this to me?