Posts

Showing posts with the label Rollup Column

Rollup Column in Dataverse

Image
📘 What is a Rollup Column in Dataverse? A Rollup Column in Dataverse is a special type of column that automatically calculates aggregated values from related child records or from a hierarchical relationship within the same table. It uses background system jobs to compute values and does not update immediately on the form. 🟢 What Rollup Columns Can Calculate SUM  - Total of related values COUNT  - Number of related records MIN / MAX  - Lowest or highest value AVG  - Average of related records Latest Date  - Most recent related activity 🟡 Important Characteristics Calculates using asynchronous jobs (not real-time) Refreshes every 1 hour or when manually recalculated Supports only numeric & date data types Requires a related child table or self-hierarchy lookup 🛠️ How to Create a ...