Rounding Numbers
↙️

Rounding Numbers

Master Tag
Tips & Tricks
Created
Jan 2, 2020 05:34 PM
Usage
Round
Divide
Web Tags
Formula
Function
Database
Alternatives
Cover
Let's simply round the number first with round:
round(prop("Completed") / prop("Subtasks"))
 
It will look something like this:
notion image
 
That round up is too dramatic. Let's try using a workaround: (100 * x) / 100
round(100 * prop("Completed") / prop("Subtasks")) / 100
 
Rounding Numbers
Task
Completed
Subtasks
Weekly Progress
Cool! Let's dive a little deeper. Suppose we want to always round the number down rather than to the nearest integer? For this use floor:
floor(100 * prop("Completed") / prop("Subtasks")) / 100
 
Always round the number up with ceil:
ceil(100 * prop("Completed") / prop("Subtasks")) / 100