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

I need to convert a rollup to a formula with summation

Asked Nov 20, 2023

393 Views
1 Answers
Open

Hey guys,

So I've been working on my tables and have built up a ton of tables, some with rollups, and some without.

My issue is that I cannot rollup a rollup from another table, so I need a formula to replicate that data.

I've been looking at Thomas Frank's video on the formula masterclass 2.0, and that map function looks good, but I cannot sum up data for the relevant field.

I have prop("Total Order Value") which is a summed-up column from my "Orders" table. How do I create a formula for this? I think if I knew this method I'd avoid rollups altogether.

asked Nov 20, 2023 by headsniper (350 points)

1 Answer

1vote

Martin_SystemsHill Points3740

Hey, it is most likely a data type issue but hard to say what exactly is happening in your case without seeing the databases themselves.

There are a few ways to correct the data type but in order to to a sum operation you might need to do add the .format().toNumber() behind the "Orders" prop to change it to the number data type.

If this doesn't work let me know and if possible share the setup and I will help with that.

answered Nov 21, 2023 by Martin_SystemsHill (3.7k points)

1vote

headsniper commented Nov 21, 2023

I've tried it, but it doesn't work, another error comes up.

Please take a look at this link and take a look at prop("Test Total Inventory Bought Count")

The formula that came out of that Prop pretty much came from a map, but I don't know how to sum that up since it is a list property. I have to get that data from a Rollup from another table, but it does not make sense to roll up the current table. Like the prop says, I'm trying to count the number of inventory used on a commission. It needs to sync from the other databases in some sort of triangle connection.

I hope that makes sense. Thanks for helping me with my tables all this time Martin. Its certainly made itself out to be an interesting project.

commented Nov 21, 2023 by headsniper (350 points)

1vote

Martin_SystemsHill commented Nov 22, 2023

Could you please share one page with all the related databases shown as in-line on the page so I can see what is happening there? It is not possible for me to figure out exactly what is happening without it.

commented Nov 22, 2023 by Martin_SystemsHill (3.7k points)

0vote

headsniper commented Nov 22, 2023

Sure I've published the other related databases, didn't notice I was missing one, thanks!

commented Nov 22, 2023 by headsniper (350 points)

Please log in or register to answer this question.

Exclusive for Notion Answers Users

• Dynamic Calendar Icon | Info | Download
Add yours here

Extend Notion Powers

⇧Your Product or Service Here⇧

...

Notion Answers

Register & Ask

Get answers

Vote and select answers

Question

I need to convert a rollup to a formula with summation

Please log in or register to add a comment.