Weighted Average Calculation & Recursion Issue

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • In Progress
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)


Photo of Devin

Devin

  • 362 Points 250 badge 2x thumb
  • confused...

Posted 6 months ago

  • 0
  • 1
Photo of Stephanie Devine

Stephanie Devine

  • 114 Points 100 badge 2x thumb
I was disappointed no one ever responded to your question, as I was wondering the same thing for a different use case...anyways there is a workaround! In case you're still needing it. It's not really recursive but can go down to as many nested 'levels' as you think will be needed:

https://community.quickbase.com/quickbase/topics/simple-recursive-formula