Formula: Round

• 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

• 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

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.

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.

//Formel um das Total auf 0 Dezimalstellen (x.)  zu runden
round(prop("Total in %") * 100) / 100

//Formel um das Total auf 1 Dezimalstellen (x.x) zu runden
round(prop("Total in %") * 1000) / 1000

//Formel um das Total auf 2 Dezimalstellen (x.xx) zu runden
round(prop("Total in %") * 10000) / 10000

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

1. Click on the property and select Edit property
2. Under Display as, select Bar or Ring