How do you compare columns in a formula when the columns are in two different subject areas?

Summary:

Specifically, we are trying to compare the resident state (from Person Real Time) to the Worked State (from Calculation Cards Real Time - Location). I'm able to select both columns, but receive an error when trying to add a formula comparing the two. I can compare state fields as long as they exist in the same subject area but when I tie in Person to get the resident state, the error persists. Can this be done in OTBI Analysis? It seems to be a simple concept.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):