Member Formula not working in Workforce

Summary:

Content (please ensure you mask any confidential information):

I need to create an account that will calculate per employee a "monthly gift amount" divided it by the "number of employees" in that employee's entity location.

There is an account where I have input the monthly gift amount per entity location - EmployGift$.

There is an account for the entity location - WorkInLocation. Each employee is assigned a location in this account.

There is an account that calculates number of employees based on active status - Emps_Reps_HC.

The member formula pulls in the correct information if I only use the individual parts of the formula: