> For the complete documentation index, see [llms.txt](https://docs.notionapps.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.notionapps.com/troubleshooting/why-are-my-rollups-on-notionapps-showing-zero-0-value-or-an-incorrect-value.md).

# Why are my rollups on NotionApps showing zero (0) value or an incorrect value?

Start with **Databases → Calculated properties**. If **Recalculate in NotionApps** is on and clickable, NotionApps evaluates Notion’s recipe itself so Home can keep a real number instead of Notion’s `0` / `0/600` page value.

Full walkthrough: [Recalculate calculated properties](https://docs.notionapps.com/how-to-guides/recalculate-calculated-properties).

***

## Reason #1 — Notion’s page API returned a bad leaf

When rollups use `average`, `min`, `max`, `sum` (and some formulas), Notion often returns `0` or `0/600` to NotionApps even though Notion’s own UI is correct.

**What to do now**

1. Open **Databases → Calculated properties**.
2. Leave **Recalculate in NotionApps** on if the switch is clickable (`sum` / `count` / `average` / `min` / `max`, or simple `prop()` math).
3. Publish, then open live Home twice. The computed number should stay.

You do **not** need to rebuild those rollups as `map()` / `length()` formulas when Recalculate is on.

If the toggle is **disabled**, we cannot evaluate that recipe yet (`formatDate`, `ifs`, `lets`, `style`, `map`, `filter`, `join`, and similar). Notion still owns the number. The older workaround still applies: add a simpler formula or rollup that we can evaluate, or keep the Notion leaf.

Example of a formula NotionApps **cannot** evaluate yet (toggle stays disabled):

```
sum(prop("Tasks").map(current.Days))/prop("Tasks").length()
```

Prefer a **sum** / **average** rollup on `Days` and leave Recalculate on.

***

## Reason #2 — A related database is not shared

Another common reason for incorrect Rollup or Formula data is because NotionApps does not have access to all the databases involved in the calculations.

#### Example Scenario

Suppose you have two databases:

* Projects
* Tasks

You’ve set up a Formula property in the Projects database (for example, “# of tasks completed”) that counts how many tasks in the Tasks database have a “Completed” status.

If NotionApps only has access to the Projects database (but not the Tasks database), Notion will return a value of 0 for the formula, even if there are completed tasks. This happens because NotionApps doesn’t have permission to read the relevant data from Tasks.

#### How to Fix

To ensure accurate data for Rollup and Formula properties:

1. Grant NotionApps access to all related databases. Make sure NotionApps is authorized to access every database referenced by your Rollup or Formula properties (if you'd like to use those properties in the app).
2. How to update database access: Go to your Account Settings and click on Manage Databases OR Open your app builder in NotionApps, visit the Databases tab, and click on Manage Databases
3. Select the related databases.

After updating access, click on the Reload Data button in your app builder. NotionApps will be able to fetch the correct values for all your Rollup and Formula properties. Then reopen **Calculated properties** so the rollup recipe can load.

***

## Reason #3 — Notion sent the value lazily

Sometimes Notion does not return the correct formula/rollup value because it loads the data in a lazy manner.

**First:** turn **Recalculate in NotionApps** on if the switch is clickable. That uses the recipe, not the lazy leaf.

If the field is unsupported, the older workaround still helps:

* If your existing property that's showing the incorrect value is a Rollup property, add a Formula property to pull the same information.
* If your existing property that's showing the incorrect value is a Formula property, add a Rollup property to pull the same information.

This forces Notion to pull the property data before sending it to us.

If you have any questions, please reach out to us at <help@notionapps.com>.

***

### Related

* [Recalculate calculated properties](https://docs.notionapps.com/how-to-guides/recalculate-calculated-properties)
* [Formulas & Rollups](https://docs.notionapps.com/screens-and-components/formulas-and-rollups)
* [16 Sep 2026 Release](https://docs.notionapps.com/release-notes/16-sep-2026-release)
