Calculating a percent

Katye Reed

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å

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

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

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

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

Andrée Starå

Great that you figured it out!

Have a fantastic weekend!

Best,

Andrée