Uses Status property.
if(prop("Status") == "Little Goal", round(prop("Little Goal") / prop("Goal") * 100) / 100, if(prop("Status") == "Goal", round(prop("Goals") / prop("Goal") * 100) / 100, if(prop("Status") == "Life Goal", round(prop("Life Goals") / prop("Goal") * 100) / 100, toNumber(""))))
Ignore Status property.
if(not empty(prop("Little Goal")), round(prop("Little Goal") / prop("Goal") * 100) / 100, if(not empty(prop("Goals")), round(prop("Goals") / prop("Goal") * 100) / 100, if(not empty(prop("Life Goals")), round(prop("Life Goals") / prop("Goal") * 100) / 100, toNumber(""))))
<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>