Combining multiple max formula criteria in OTBI resulting in no values returning

Summary:

I'm having trouble pulling in someone's latest record or assignment in a report without it creating multiple line items for their various Job Names.

When using a few max formula's the Job Name column appears blank even though an employee might have 3 or more jobs

Content (please ensure you mask any confidential information):

Pulling in the most recent hire date using this formula in the column: MAX("Worker"."Employee Hire Date" BY "Worker"."Person Number")

Also pulling in the latest assignment start date by using this formula in the column: MAX("Workforce Management - Worker Assignment Real Time"."Worker"."Assignment Start Date" BY "Workforce Management - Worker Assignment Real Time"."Worker"."Person Number")