I need to add a criteria on a transaction saved search to include only POs whose Creator's department is different from the Requestor's (Employee) department. Formula (Numeric) CASE WHEN {user.department} != {requestor.department} THEN 1 ELSE 0 END Formula is equal to 1 It's throwing an error. For some reason, I think there's no Created By join fields.

I would start by putting requester.department into its own results column and getting that to display the department. Also user is probably the logged in user not the creator. Try putting that to its own column while you work through.