Rounding

Formula

(prop("Current Value") - prop("Initial Value")) / (prop("Target Value") - prop("Initial Value"))

Formula (round)

Only works with numbers equal to or above 1, as decimal numbers round to 1 (100%) or 0 (0%).

round((prop("Current Value") - prop("Initial Value")) / (prop("Target Value") - prop("Initial Value")))

Formula (round * 100 / 100)

Multiplying the result by 100 before it's rounded moves the decimal place so the result is more than 1, and then dividing it after moves the decimal place back so the result is below 1.

round((prop("Current Value") - prop("Initial Value")) / (prop("Target Value") - prop("Initial Value")) * 100) / 100

<aside> <img src="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1649d2f9-1b45-478a-86b4-341fbe27e06f/benny.png" alt="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1649d2f9-1b45-478a-86b4-341fbe27e06f/benny.png" width="40px" /> By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!

</aside>