Formula: Round

Formula: Round

Published
July 13, 2023
Author

Beli Löw

Lecture
2 min

← All Articles

image

Simple rounding

icon
How to Round Numbers with a Notion Formula
  • Round to 0 decimal places: round(x*1)/1
  • Round to 1 decimal place: round(x*10)/10
  • Round to 2 decimal places: round(x*100)/100

In this example, we round Our Number to 0, 1, and 2 decimal places.

image
//Rounding to 0 Decimal places
round(prop("Our Number") * 1) / 1
//Rounding to 1 Decimal places
round(prop("Our Number") * 10) / 10
//Rounding to 2 Decimal places
round(prop("Our Number") * 100) / 100
The formulas for this example looks like this.

Rounding with Percent

icon
In Brief
  • Round to 0 decimal places: round(x*100)/100
  • Round to 1 decimal place: round(x*1000)/1000
  • Round to 2 decimal places: round(x*10000)/10000

Let's imagine we want to evaluate applicants in the categories of hard skills, soft skills, and team match. Each category is to be rated on a scale of 1 to 10. We want to round the result and display it with a progress bar.

image
icon
Step-by-Step Guide

First, the first 3 values are summed in the formula Total Score.

prop("Hard-Skills[1-10]") + prop("Soft-Skills[1-10]") + prop("Team-Match[1-10]")

Afterward, we can calculate the percentage with the formula Total in %. The maximum value in our example is 30.

1 / 30 * prop("Total Score")

This gives us a number but not yet the percentage value. Now the field "Total in %" must be formatted as Percentage.

image
  1. Hover over the formula with your mouse
  2. Click on the number 123
  3. Select Percentage

Afterward, you can use the following formulas to round percentages.

//Formula to round the total to f 0 Dezimalstellen (x.)  zu runden
round(prop("Total in %") * 100) / 100

//Formula to round the total to 1 Dezimalstellen (x.x) zu runden
round(prop("Total in %") * 1000) / 1000

//Formula to round the total to  2 Dezimalstellen (x.xx) zu runden
round(prop("Total in %") * 10000) / 10000
icon
Notioneers Tip: While developing a formula, I break it down into several steps (properties) to better understand it. Once everything works, I combine them into a complete formula.

This is what the function looks like when all the steps are included in one formula. See the field All in one formula.

round(1 / 30 * (prop("Team-Match[1-10]") + prop("Hard-Skills[1-10]") + prop("Soft-Skills[1-10]")) * 100) / 100
All steps in one formula.

Display Progress Bar in Notion

If we want to display the whole thing with a progress bar, we can easily set it in the property.

image
icon
How to Display the Value as a Progress Bar
  1. Click on the property and select Edit property
  2. Under Display as, select Bar or Ring
image
icon
image

Beli Löw

Beli is an IT project manager, tool enthusiast, entrepreneur and has organized his whole life with Notion. His news sources are release notes from tools. There is (almost) no feature or shortcut that he does not know.

More Articles