Percentage Difference

kjoseph87

Hi Community,

I'm working on creating a very intuitive dashboard and I need to calculate the percentage between two different months. How do I calculate it in Smart sheet?

 

For example, let's say the total for May is 352,000 and the total for June is 226,000 how can I calculate the percentage difference between May and June?

 

Andrée Starå

Hi,

Is everything coming from the same sheet? You could either calculate the percentage on the sheet or another that I call, Master Metric Sheet.

My preferred method is the Master Metric Sheet because it makes it easy to collect and calculate everything in one place.

Would any of those options work for you?

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting