Example - Formula using Lookup Fields | Quickbase

Example - Formula using Lookup Fields

This is an example app to answer the query in this community question:
- incorporate a lookup field from a parent table to calculate a value using formula fields
- 2 table: Companies, Debts
- LPInterest RateTotal is a Formula-Numeric field on the Company table
- the Debt table looks up that value in [Company - LPInterest RateTotal]
- the Interest fields uses that lookup field as part of the formula calculations
Try The App
Write A Review