Nigtellios/1.md

Last active August 20, 2023 23:00

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/Nigtellios/647336b9c858c67748c98f2dcd37028c.js"></script>
Save Nigtellios/647336b9c858c67748c98f2dcd37028c to your computer and use it in GitHub Desktop.

Download ZIP

Notion Formulas

Raw

1.md

If field with percent value > 0, subtract % from field or show other field.

if(
	prop("PERCENT") > 0,
	subtract(
		toNumber(prop("VALUE A")),
		multiply(divide(prop("PERCENT"), 100), toNumber(prop("VALUE A")))
	),
	prop("VALUE B")
)

Converting to Notion notations:

if(prop("PERCENT") > 0,subtract(toNumber(prop("VALUE A")),multiply(divide(prop("PERCENT"), 100), toNumber(prop("VALUE A")))),prop("VALUE B"))