Notion Answers

Help between Notion users


Register & Ask

It's free & easy

Get answers

Answers, votes & comments

Vote and select answers

Receive points, vote and give the solution

Question

1vote

Rollups not working (no value retrieved)

This is what I would like to achieve:

One with details of expenses, ie

  • Food A $50
  • Grocery A $20
  • Grocery B $50

One with the total Expense:

  • Groceries = $70

I have already linked them up via relations, and selected rollups for the amount.
The value returned on my total expense is zero.

Any idea why?

1 Answer

0vote

polle Points79930

Not sure how you have the structure in Notion and that is the most important thing.

Here is how the structure should be.

You need 2 databases, one for expenses and one for the categories.
Relate both databases.
When you add a new expense, you select the category from the relation and add a total.
Add an expenses Rollup in the categories database, pull the total from the expenses database.

Rollup Config: Relation > Expenses, Property > Total, Calculate > Sum.

That will work as you need.

1vote

Susan commented

Thank you - my mistake was not selecting the relevant category from the relation. I left it blank ( didn't link the relevant category individual; pages) , and hence why.

Thank you so much!

0vote

polle commented

Glad to help. Please select the answer it to mark the question as solved.

Please log in or register to answer this question.

...

Welcome to Notion Answers, where you can ask questions and receive answers from other members of the community.

Please share to grow the Notion Community!

Connect