Skip to content

How to Fix Notion Rollup Property Not Calculating Correctly

DodaTech Updated 2026-06-24 3 min read

In this tutorial, you'll learn about How to Fix Notion Rollup Property Not Calculating Correctly. We cover key concepts, practical examples, and best practices.

Notion rollup properties aggregate data from related database pages through a relation. When a rollup shows incorrect totals, empty results, or only counts one related page, the relation is not set up correctly, the rollup function is wrong, or the related pages are missing the source property.

The Problem

You set up a rollup to sum "Price" from all related items, but it shows 0, shows only one item's price, or displays the wrong total.

Wrong approach — deleting and recreating the rollup property.

The Fix

Check the relation property is populated:

1. Open a parent page
2. Look at the relation property — are related pages linked?
3. If the relation is empty, the rollup has nothing to aggregate
4. Add related pages to the relation

Check the rollup configuration:

1. Open the database → "..." → Properties → click the rollup property
2. Verify "Relation" points to the correct relation property
3. Verify "Property" (the source property in the related database) is correct
4. Verify "Calculate" — Sum, Count, Average, Min, Max, or Show Original

For wrong calculation type:

Count = number of related pages (ignores property value)
Sum = adds up all values of the property
Show Original = displays values as a list

Expected output:

Rollup shows the correct aggregated value
Sum adds all related values correctly
Count shows the exact number of related pages

Prevention Tips

  • Verify the relation is populated before configuring the rollup
  • Use "Sum" for numeric totals, "Count" for item counts, "Show Original" for text lists
  • Test with one related page first, then add more to verify aggregation
  • Ensure the source property type matches the rollup function (Sum needs numbers)
  • Name rollups descriptively: "Total Price (Rollup)" instead of just "Rollup 1"

Common Mistakes with rollup property

  1. Non-exhaustive pattern matches that compile with warnings then crash at runtime
  2. Misunderstanding that String is [Char] with poor performance for large text operations
  3. Using foldl instead of foldl' causing stack overflow on large lists

These mistakes appear frequently in real-world NOTION code. DodaTech's contributors have identified these patterns through analysis of open-source projects and production systems.

Practice Exercise

Write a pure function that safely divides two integers using Maybe, then test it with edge cases like division by zero and negative numbers.

This exercise reinforces the concepts covered in this guide. Try implementing it before checking online solutions.

FAQ

### Why does my rollup show "0" when there are related pages?

The rollup's source property in the related database may be empty or set to a non-numeric type. Check the "Property" field in the rollup configuration — it must point to a numeric property for "Sum" to work. If it points to a text or select property, Sum returns 0.

Can a rollup access properties from multiple levels deep?

Notion supports two-level rollups: Database A relates to Database B, and Database B relates to Database C. A rollup in Database A can aggregate data from Database B, and a rollup in Database B can aggregate from Database C. However, a rollup in Database A cannot directly aggregate from Database C.

What is the difference between Rollup and Relation properties?

Relation properties create links between pages. Rollup properties calculate values from linked pages. A relation is required before you can create a rollup. The relation stores the links; the rollup reads them and performs calculations.

Related: DodaTech's Rollup Performance Analyzer profiles Notion databases for rollup calculation efficiency, identifying large relation sets that slow down page loads. Use with DodaZIP for database backup.

Built by the developers of DodaTech

Doda Browser, DodaZIP & Durga Antivirus Pro