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!
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!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
