Adding Custom Percentage Complete Column | Community
Skip to main content
K
khryc
Level 2
April 13, 2023
Solved

Adding Custom Percentage Complete Column

  • April 13, 2023
  • 1 reply
  • 928 views

Hello,

I am trying to figure out how to add a percentage complete column at the project level based on Actual Project Hours versus Planned Project Hours.

This would be different than the regular built-in percentage complete, which doesn't work for us based on the way we set up our projects.


For example, if the total planned project hours is 100 and the actual project hours is 70, the remaining hours are 30, so the percentage complete is 70%, so I am looking for simple text needed to represent the 70% calculation.

 

Thanks

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by JoaquinAv

Hi khryc, 

 

If I understand your question and the example you showed, you want to see how much of the Planned hours you used when a project is complete. Is that correct?

 

You could write text mode as the following. 

displayname=Act vs Pln Hours %
valueexpression=CONCAT(ROUND(DIV({actualWorkRequired},{workRequired})*100),"%")
valueformat=HTML

 

If this solved your problem, I invite you to consider marking it as a Correct Answer to help others who might also find it of use.

1 reply

JoaquinAv
JoaquinAvAccepted solution
Level 3
April 13, 2023

Hi khryc, 

 

If I understand your question and the example you showed, you want to see how much of the Planned hours you used when a project is complete. Is that correct?

 

You could write text mode as the following. 

displayname=Act vs Pln Hours %
valueexpression=CONCAT(ROUND(DIV({actualWorkRequired},{workRequired})*100),"%")
valueformat=HTML

 

If this solved your problem, I invite you to consider marking it as a Correct Answer to help others who might also find it of use.

K
khrycAuthor
Level 2
April 13, 2023

Joaquin,

That is exactly what I was looking for...thanks so much

Would you be able to just show me how I can display the % sign in my results? it currently just shows the number.

JoaquinAv
JoaquinAv
Level 3
April 13, 2023

That's great!

 

When I originally added the text expression, I think I had the "%" on the wrong side of the 2nd closed parenthesis. It should be accurate now. You can copy the code as it is now and it should show the percent in the results. 

 

Terms & ConditionsAccessibility statement

Loading footer...