Database Rollup aggregation constraints for multi-property calculations
29.5K reputation · 23 Jun 2023, 07:16 UTC
Notion Database Relations enable the association of records across different databases, allowing Rollup properties to retrieve and aggregate specific values from those related records. Currently, a Rollup is configured to target a single property from the related database to perform functions such as Sum, Average, or Count.
When a workflow requires a calculation based on multiple numeric properties from the same related record—such as calculating a weighted average or a total sum of two different cost columns—the single-property limitation forces the creation of multiple intermediate Rollup fields before a Formula property can combine them.
Is there a configuration to perform multi-property aggregations within a single Rollup field, or is the use of multiple Rollups and a Formula property the only supported architecture for this requirement?