Question

The 'show original' and the ‘sum' options in a few of my rollups are giving me different results. This is effecting the formulas that I want to perform in the receiving database. any help will be appreciated.

Comments

Show original & sum options in Notion should show different results, so it is not clear what the problem is.

Please share some data to understand it.

• You have a database with (text, numbers, dates, and?).
• You have another database and after relating them you are using a Rollup to pull (numbers, text, dates or???).
• The rollup shows 50 as a number or ? what exactly.
• Which formulas are you using, expecting what.
• You expect to get "what" and you getting "what" instead?
• Etc...

The same for the second Rollup and all the information possible to understand the complete scenario in Notion.

---

Thank you for the swift response Pollo

Please share some data to understand it.
You have a database with (text, numbers, dates, and?).
You have another database and after relating them you are using a Rollup to pull (numbers, text, dates or???).

the information I am trying to rollup is a tonumber formula

The rollup shows 50 as a number or ? what exactly.
the original value rollup is showing ‘324’ which is the correct value I want to be presented.
when I change it to a sum it shows '-1054’ it also shows this in the formula when I input the property as an original value or the sum.

Which formulas are you using, expecting what.
I want to use the formula to do a simple subtraction but I need the value to be correct

The same for the second Rollup and all the information possible to understand the complete scenario in Notion.
ultimately what I am trying to create is a food planner that tracks my macros and calories. the user can plan dishes in advance and the user can also add adhoc additions to the daily food intake. this resulting in the combine subtraction against the target calories along with the food planner aspect.
so the target calories - planner calories - adhoc calories is the goal that I am trying to get to.

Answer 1

If you select sum, it will sum everything, if you select original it will show the exact number in the rollup.

So show original & sum options in Notion should show different results in the Rollups.

Please share exactly what you have in original column, what you have in sum column, and mention what result you should have and what are you are getting instead.

It is complicated without seeing anything and imagining how are things in your Notion setup, but I believe you need to show original in the 3 rollup columns and add a fourth one with a formula to do the math.