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
Help between Notion users
It's free & easy
Answers, votes & comments
Receive points, vote and give the solution
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
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.