Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-01-2021, 12:48 PM
advillanuevag advillanuevag is offline Project Summary Task Percent Complete round with no decimals Windows 10 Project Summary Task Percent Complete round with no decimals Office 2019
Novice
Project Summary Task Percent Complete round with no decimals
 
Join Date: Apr 2021
Posts: 5
advillanuevag is on a distinguished road
Smile Project Summary Task Percent Complete round with no decimals


How can I do to show the project summary task percent complete as a number with decimals?.

For example, when I update the percent complete of several project sub-tasks, Microsoft Project shows the project general percent complete as 1% when It should show 1,41%.

Thank you all.
Reply With Quote
  #2  
Old 04-02-2021, 05:18 AM
ProjectPlanner's Avatar
ProjectPlanner ProjectPlanner is offline Project Summary Task Percent Complete round with no decimals Windows 10 Project Summary Task Percent Complete round with no decimals Office 2019
Novice
 
Join Date: Mar 2021
Location: UK
Posts: 12
ProjectPlanner is on a distinguished road
Default

Use a custom text field for your decimal % and enter the formula shown in the screenshot below. Note that both tasks & task summary will have % complete with decimals.



Also select tick the radio button for task summary rows to use formula too.





=
jerome
Planners' Place
Reply With Quote
  #3  
Old 04-02-2021, 08:40 AM
advillanuevag advillanuevag is offline Project Summary Task Percent Complete round with no decimals Windows 10 Project Summary Task Percent Complete round with no decimals Office 2019
Novice
Project Summary Task Percent Complete round with no decimals
 
Join Date: Apr 2021
Posts: 5
advillanuevag is on a distinguished road
Default

Dear Jerome,

when I write the formula you kindly sent me, Project says that there is an error at "#.00"

I have written the formula like this because I am using Microsoft Project in the Spanish Language:

Format([Duración real]/[Duración]*100,"#.00") & " %"

What can I do to resolve the error?

Thank you, have a great day.
Reply With Quote
  #4  
Old 04-02-2021, 12:39 PM
ProjectPlanner's Avatar
ProjectPlanner ProjectPlanner is offline Project Summary Task Percent Complete round with no decimals Windows 10 Project Summary Task Percent Complete round with no decimals Office 2019
Novice
 
Join Date: Mar 2021
Location: UK
Posts: 12
ProjectPlanner is on a distinguished road
Default

OK try either these.

Format([Actual Duration]/[Duration],"0.00%") or Format([Actual Duration]/[Duration],"Percent")

I don't speak Spanish so can't translate it but all 3 formulas work for me.
Reply With Quote
  #5  
Old 04-19-2021, 11:52 AM
advillanuevag advillanuevag is offline Project Summary Task Percent Complete round with no decimals Windows 10 Project Summary Task Percent Complete round with no decimals Office 2019
Novice
Project Summary Task Percent Complete round with no decimals
 
Join Date: Apr 2021
Posts: 5
advillanuevag is on a distinguished road
Default

Hi Jerome, I marked this threshold as solved some minutes ago, please pardon me, I am new in the forum and I didn't know how to mark a threshold as solved, but you solved it some days ago. Thank you very much for your help to solve the problem.
Reply With Quote
Reply

Tags
percent complete, project management, rounding

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
% Complete for Summary Task not Calculating? lynn0712 Project 0 12-20-2018 09:41 AM
tracking progress - percent complete of a task started earlier than scheduled eblack89 Project 0 04-04-2018 03:25 PM
Project Summary Task Percent Complete round with no decimals Showing how much work is required to complete a project according to summary task start/end times PDX-ADM-TRM01 Project 1 03-30-2015 04:05 PM
Rollup Summary Tasks to Project Summary Task shep555 Project 1 05-24-2014 12:28 PM
Project Summary Task Percent Complete round with no decimals summary task calculating from project start ketanco Project 1 01-02-2012 02:34 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 09:34 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft