Weighted Average Calculation & Recursion Issue

I have two tables: 1. Properties (parent); and, 2. Buildings (child). I want to have a gross rental income data entry field in the Properties table that populates each Building's portion of rental income based on a weighted average of square footage.

Unfortunately, using summary fields that then lookup down to Buildings results in what QuickBase has called "recursion" that does not allow totaling of gross rents, so I cannot then total the different rent types in the Buildings record, or other totals. 

Is there a work around to this?

Conceptually, this is what I'm trying to achieve:

Properties Table:
[Gross Residential Rent Income] (dat

&

[Gross Commercial Rent Income]


Buildings Table:
[Gross Building Residential Rent Income (Summary Field Lookup from Properties)]*
([Building X Square Footage] /
[Gross Building Square Footage (Summary Field Lookup from Properties)])=
[Building X Residential Rent Income] Currently returning a 'recursion' error (see screenshot with QuickBase help)

Repeat for 'Commercial Rent', then...

[Building X Residential Rent Income]+
[Building X Commercial Rent Income]=
[Building X Total Rent Income]  
From here...

Properties Table:
[Buildings Total Rent Income (Summary Lookup)