Joined: 25 Apr 2007
Location: United States
Online Status: Offline
Posts: 2
Topic: Excluding data its not supposed to Posted: 25 Apr 2007 at 8:09am
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?
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum