|
#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
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 |
#3
|
|||
|
|||
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. |
#4
|
||||
|
||||
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. |
#5
|
|||
|
|||
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.
|
Tags |
percent complete, project management, rounding |
|
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 |
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 |
summary task calculating from project start | ketanco | Project | 1 | 01-02-2012 02:34 PM |