Layer Maker: Using Formulas to Reference Data Across Categories in Layer

Formula fields in Layer allow you to reference and aggregate data across multiple categories. In this video, you will learn how to use formulas to pull related information across categories like products, rooms, furniture, and departments. We start with a simple example that shows how to list the rooms where a product is located and display quantities by location. The lesson then walks through more advanced examples, including calculating total area by department and estimating FF&E costs by referencing rooms, model elements, related products, unit costs, and quantities. You will see how formulas can traverse multiple relationships and how to summarize results to get totals at the department and project level.