I have written an OTBI analysis containing several fields however I am having an issue when I create a field with a Case statement to compare the below fields.
Subject Area: Person Real Time:
· "Person Address"."Region2"
· "Person Legislative Information"."PER_PERSON_LEGISLATIVE_DFF_PAYROLL__TAX__STATE_"
Subject Area: Worker Assignment Real Time:
· "Location"."Region 2"
When I compare "Person Address"."Region2" AND "Person Legislative Information"."PER_PERSON_LEGISLATIVE_DFF_PAYROLL__TAX__STATE_" formula works as expected and returns ‘Match’ and ‘No Match’.
However when I create a field and try to compare either "Person Address"."Region2" AND "Person Legislative Information"."PER_PERSON_LEGISLATIVE_DFF_PAYROLL__TAX__STATE_" with "Location"."Region 2" No data is returned in the fields (Home VS Work State and Work VS Payroll Tax State).
Any help would be appreciated.
Thanks
Scott
