Notion Rollup Cannot Calculate Sum: Common Cause

You added a Rollup property to a Notion database and selected Sum as the calculation. The rollup column shows no value or displays an error instead of a total. This problem usually happens because the source property type or the relation setup does not support numeric aggregation. This article explains the exact causes of a failed rollup sum and shows how to fix the database structure so the calculation works correctly.

Why a Notion Rollup Sum Fails to Show a Value

A Rollup property in Notion reads values from a related database and performs a calculation such as Sum, Average, or Count. For Sum to work, every value in the source property must be a number. If any value is text, empty, or the wrong type, the rollup displays nothing or shows an error. The most common root causes are a source property that is not a Number type, a relation that is not correctly established between the two databases, or a Formula property that outputs a string instead of a number.

Source Property Must Be a Number Type

The rollup can only sum properties that store numeric data. The following property types support Sum: Number, Rollup (that itself returns a number), and Formula (if the formula output is set to Number). Properties such as Text, Select, Multi-Select, Date, and Email cannot be summed. If you select one of these as the source, the rollup will not display a value.

Relation Must Be Correctly Configured

A rollup depends on a Relation property that links two databases. If the relation is missing, empty, or points to the wrong database, the rollup has no rows to read. The relation must exist in the same database where you are adding the rollup. Each row in the source database must have at least one related row in the target database for the rollup to find data.

Formula Property Output Type

A Formula property can return a number, a string, a date, or a boolean. When you create a formula, Notion automatically detects the output type based on the formula logic. If the formula contains a text function like concat() or format(), the output becomes a string even if the result looks like a number. A string cannot be summed. You must force the formula to output a number by removing any text functions or by using toNumber() to convert the result.

Steps to Fix a Rollup That Cannot Calculate Sum

Follow these steps in order. After each step, check whether the rollup shows the correct sum.

1. Check the source property type
   Open the database that contains the rollup. Click on the property name listed as the source in the rollup configuration. In the property settings, confirm that the type is Number, Formula (with numeric output), or Rollup (that itself returns a number). If the type is Text, Select, Date, or any other non-numeric type, change it to Number or create a new Number property with the values you want to sum.
2. Verify the Relation property
   Open the database where the rollup is placed. Locate the Relation property that the rollup uses. Click on the relation to see which database it connects to. Make sure the relation is not empty for the rows you expect to sum. If the relation is empty, add related rows in the target database and link them using the relation property.
3. Inspect each related row for blank or text values
   Go to the target database (the one the relation points to). Look at the source property in every row that is linked to the rollup database. If any row has a blank, text, or non-numeric value, the rollup sum may fail. Fill in a numeric value or delete the row if it is not needed. For blank cells, enter 0 if a zero value is acceptable for your calculation.
4. Fix a Formula property that outputs a string
   If the source property is a Formula, click on the formula to edit it. Review the formula for functions that return text, such as format(), concat(), or replace(). Replace these with numeric functions or wrap the result with toNumber(). For example, change prop("Price") + " USD" to prop("Price") or toNumber(prop("Price")).
5. Recreate the Rollup property
   If the above steps do not resolve the issue, delete the rollup property and create it again. Click the database menu (three dots in the top right). Select Properties and find the rollup. Click the three dots next to the rollup property and choose Delete. Then add a new property, select Rollup as the type, choose the correct relation, select the correct source property, and set Calculate to Sum.

If Notion Still Shows No Sum After the Main Fix

Rollup shows 0 instead of the expected total

This usually means the source property contains zero values or the relation points to rows that have no numeric data. Check each related row. If the source property is a Formula, verify that the formula does not return an empty string when conditions are not met. Replace empty string returns with 0.

Rollup displays “Invalid” or “Error”

This error appears when the source property contains a value that cannot be converted to a number. Common culprits are text that looks like a number but includes spaces, commas, or currency symbols. For example, “1,234” or “$50” will cause an error. Clean the data by removing symbols or use a Formula property to strip non-numeric characters before summing.

Rollup works for some rows but not others

This happens when only some rows in the target database have a relation link. Check each row in the source database that should contribute to the sum. If a row has no relation, the rollup skips it. Add the missing relation links to include those rows.

Rollup Sum vs Average vs Count: When to Use Each

Calculation	Best Use Case	Data Type Required
Sum	Total of numeric values such as revenue, hours, or quantity	Number, Formula (numeric), Rollup (numeric)
Average	Mean of numeric values such as average rating or average cost	Number, Formula (numeric), Rollup (numeric)
Count	Number of related rows regardless of value	Any property type
Count Values	Number of related rows that have a non-empty value in the source property	Any property type
Max / Min	Highest or lowest numeric value in the set	Number, Date, Formula (numeric or date)

Use Sum only when you need a total. If you only need to know how many related items exist, use Count or Count Values instead. Count does not require numeric data and will never fail due to type mismatch.

You can now identify why a Notion rollup sum fails and correct the source property type or relation setup. After making these changes, test the rollup by adding a new row with a known numeric value and verifying the total updates. For advanced use, combine a Formula property with toNumber() to clean imported data before summing.