Calculating a percent

Katye Reed · 12/10/18

Hello,

I am struggling to calculate the % complete based upon Target Savings / Realized Savings. I am trying to track the % complete of task based upon how much of our target savings we have realized.

Any suggestions are appreciated.

Thank so much,

Katye

Andrée Starå · 12/10/18

Hi Katye,

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help.

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Paul Newcome · 12/10/18

Just wanted to follow this as I track % complete pretty regularly. Curious if there's an easier way than what I am using.

Katye Reed · 12/10/18

Hello,

I have attached a screen shot of the columns in question. The task name represents the metric we are trying to track. The Target Metric column is the $ amount or number we hope to achieve. The Realized metric is where we would track amount to date. For example, a target is to save 500k. For that month we realized 25,000. In the percent complete, we'd like to have the % complete be based off how much we have realized in comparison with the target and display as a %.

I'm not sure what formula could be used to achieve this.

Thanks for the assistance.

Katye Reed · 12/12/18

I figured it out. It is as simple as dividing Realized/Target in the percent complete column.

Andrée Starå · 12/14/18

Great that you figured it out!

Have a fantastic weekend!

Best,

Andrée

Calculating a percent

Comments

Help Article Resources

Categories