how to insert the associated appointments from a contact in a formula field

A percentage of the total records/accounts who are now on the 4th appointment for all the accounts that completed the first 3 visits. The formula field is required on Location object, but the data needed is on Appointment and Accounts