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

How do you select to display only positive numbers from a rollup

I have rolled up a list of numbers and I would like to display only the amount of the positive numbers in that list.

any help will be appreciated

1 Answer

0vote

polle Points77470

You will need an extra property using a formula to calculate that and a filter.

Here is a simple example without knowing how is your setup.

1- Make sure your rollup is a number.
2- Create a new column using formula.

if(prop("Rollup") > 0, prop("Rollup"), 0)

That tells Notion: If the prop Rollup is greater than cero, show the prop Rollup, otherwise show cero.

3- Hide the Rollup property.

4- Then just filter the database to show only things that are not cero.

Hope that helps.

0vote

Daniel01 commented

Thanks @polle for this, but I meant when the roll up items are in the same cell. eg.
| 12, -23 , 34 , -17 | in this case is there a way to show only positive numbers.

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