Phone numbers repeating instead of suppressing duplicates

Summary:

Mobile phone and home phone number columns are repeating even though they are duplicates and the columns are set to repress.

Content (please ensure you mask any confidential information):

I'm using a formula to select for a worker's mobile phone and home phone regardless of which phone is set as default, using MAX(CASE WHEN "Person Phones"."Phone Type Code" = 'HM' THEN "Person Phones"."Area Code"||'-'||"Person Phones"."Phone Number" END by "Worker"."Person Number")
and MAX(CASE WHEN "Person Phones"."Phone Type Code" = 'H1' THEN "Person Phones"."Area Code"||'-'||"Person Phones"."Phone Number" END by "Worker"."Person Number")