Reference / Computed Columns

# Rollup Column

## Perform calculations on columns, such as count, average, and sum.

The rollup allows you to perform a calculation on an entire column or a Relation. The most basic computation for the rollup is Count.

For example, in the image below we create a rollup column that counts the number of items in the `Animals` column. The result is a number: the total number of animals that fit that parameter.

## Column or relation source

For example, in the app below we have a list of people who all have tasks. The `Tasks` column is a relation that pulls in every task assigned to each individual person. We can then create a rollup column that counts the total number of tasks for each person.

To create a rollup column:

• Open the data editor and add a new column.
• Label your column and select “rollup” as the column type.
• Choose with existing column or relation you want to perform your calculation on.
• Choose which calculation you want to perform.
• Specify the precision in decimal points for your calculation, as well as if you want to use a group separator or add units to the calculation.
• Select Done, and you will immediately see your calculations fill the column.

## Calculations

The Rollup Column can perform different calculations based on the data it finds in the column or relation you select.

### Numbers

The rollup column can calculate the Count, Count Unique, Sum, Average, Range, Minimum, and Maximum of number values.

### Dates

The Rollup Column can calculate the Count, Count Unique, Earliest, and Latest of date values.

### Boolean

The Rollup Column can calculate the Count, Count Unique, Count True, Count False, All True, and Some True.

### Text

The Rollup Column can calculate Count or Count Unique.

Updated 6 days ago