Simple Formula for Grouped Records

David_Marks · ‎Jul 04, 2023

Hoping for some help with how to setup for a formula to calculate the "Stabilized Occupancy" as shown below (% shown is wrong and is a placeholder in my table design).

On a table, I have "Leased" "KV" and "Committed". I need to calculate the following

(Leased - KV + Committed) / 1,000,000

(633470 - 45472 + 290) / 1,000,000

What would be my best solution to pull this formula in the "number" Element in my Interface? Thanks!

Vic_Airtable · ‎Jul 10, 2023

Hi @David_Marks

Summary bar values (whether from another table or the same table) are a type of metadata not currently accessible by record-level formulas. To output the sum of those fields into a record that you can then reference to perform a calculation, you could use a linked record field and a rollup field like in our guide here: Find the sum of an entire field. You'd then use that formula field in your Number element in your Interface. Hope this helps point you in the right direction!