A table calculation summarizes the values of one column in a cell at the bottom of the table. It's meant to help you see totals and counts without building a report.
You can use table calculations for many things, including:
Summing the monthly rent of all properties in a view.
Counting how many tasks are not complete yet.
Note:
Available calculations depend on the field. A number can be summed, a text can only be counted.
Only table views have calculations. Boards and lists don't.
Who can use table calculations?
Table calculations are available on all plans: Free, Plus, and Premium.
Everyone who can open the table can add calculations. They're part of the view settings, so to save them in a team view, you need
Full accessorCan share. Learn more about saving views →
Add a calculation
Open a table view.
Scroll to the bottom of the column you want to summarize. The cell reads
Calculate. Under the first column it's always visible; under the other columns, it shows when you hover over the bottom row.Select the cell and choose a calculation.
To remove a calculation, select the cell again and choose None.
On a phone, the table shows the calculations that are already set, but you can't add or change them.
Calculations you can choose
Every field type has these calculations:
Count all: the number of records.Count not emptyandCount empty: how many records have or don't have a value.Percent not emptyandPercent empty: the same as a share of all records.
More are offered for these fields:
Numberfields, andCalculationfields that return a number:Sum,Average,Median,Minimum, andMaximum.StatusandTask listfields:Count completeandCount incomplete.
FAQs
Can I sum a Calculation field?
Can I sum a Calculation field?
Yes, if the field returns a number. Fields that return text or dates only offer counts. Learn more about the calculation field →
Do calculations count records I filtered out?
Do calculations count records I filtered out?
No. Calculations only include the records that match the filters and the search of the view, and that you're allowed to see.
Can I add a calculation to every column?
Can I add a calculation to every column?
Yes. Each column has its own Calculate cell.
Can I add a calculation on my phone?
Can I add a calculation on my phone?
No. On a phone, you can see the calculations of a table view, but you can't add or change them. Use Tape on a computer instead.
Can I use calculations in a board or list?
Can I use calculations in a board or list?
No. Calculations are only available in table views.
Where can I find an overview of views?
Where can I find an overview of views?
In Views, filters, sorts & groups →. It explains Table, Board, and List layouts, team and private views, and how filters, sorts, and groups fit in.
Still have more questions? Find answers and get help from community experts in the Tape community →.
