Percentage Increase/Decrease

Calculate the percentage of the increase or decrease between two numbers.

% Increase/Decrease
Copy  •  js
if(empty(prop("Start")) and prop("Start") != 0 or empty(prop("End")) and prop("End") != 0, "", if(prop("Start") == prop("End"), "No Change", format(round(abs((prop("Start") - prop("End")) / prop("Start")) * 10000) / 100) + "% " + if(prop("Start") < prop("End"), "increase", "decrease")))
Emoji Version
Copy  •  js
if(empty(prop("Start")) and prop("Start") != 0 or empty(prop("End")) and prop("End") != 0, "", if(prop("Start") == prop("End"), "🔹 No Change", if(prop("Start") < prop("End"), "🔺  ", "🔻 ") + format(round(abs((prop("Start") - prop("End")) / prop("Start")) * 10000) / 100) + "% "))
Previous & Next