Project Percentage Calculation

psierra
Kilo Contributor

Hi all

 

Can you give me some guidance regarding "How project percetange is calculated",

In mi case, y have a project with 6 project task. 3 of those task are on closed complete status, so its individual percentage is 100%, the other 3 task are on closed omited status, so its individual percentage is 0% ( i supposed it is correct since the task is ommited)

But project, is at 1.13% and i dont found logic on this calculation, since total days of 3 completed tasks are 15 days and total days of 3 omitted tasks are 25 days so in basic calculation i supose project must be at least on 30% more or less. or in a 100% because the other 3 task are omitted ( i asume this as cancelled).

 

Is it correct?, can you give me a little help on this?

 

Thanks in advance, best regards

1 ACCEPTED SOLUTION

Akhilesh6
ServiceNow Employee
ServiceNow Employee

if below are the tasks in a project 

find_real_file.png

Worked duration for each task can be calculated through below formula

Worked Duration for a Task = Task duration * (%complete/100)

 

find_real_file.png

Total Duration  = Sum of Durations of  (T1 + T2 + T3) = 3 + 10 + 4 = 17

Total Worked Duration = Sum of Total Worked Durations of  (T1 + T2 + T3) = 1.5 + 10 + 0 = 11.5

Percent Complete of Project = (Total Worked Duration / Total Duration)*100 ==>  11.5/17 = 67.65 %

 

View solution in original post

6 REPLIES 6

Namita Mishra
ServiceNow Employee
ServiceNow Employee

Hi,

Check by using following formula:

Project percentage complete = (Worked Duration / Total Duration)*100

Worked duration = Task duration * (Task %complete/100)

 

Thanks,

Namita Mishra

 

Akhilesh6
ServiceNow Employee
ServiceNow Employee

if below are the tasks in a project 

find_real_file.png

Worked duration for each task can be calculated through below formula

Worked Duration for a Task = Task duration * (%complete/100)

 

find_real_file.png

Total Duration  = Sum of Durations of  (T1 + T2 + T3) = 3 + 10 + 4 = 17

Total Worked Duration = Sum of Total Worked Durations of  (T1 + T2 + T3) = 1.5 + 10 + 0 = 11.5

Percent Complete of Project = (Total Worked Duration / Total Duration)*100 ==>  11.5/17 = 67.65 %

 

Think my project was corrupted since i load it from an importset, but thanks for your detailed explanation, it helps me so much

 

Regards

Hello,

 

My project module has setup into 5 phases. Initiation, Planning, Execution, Delivery & Close out. How will you calculate % completed based on these 5 phases. Do I need to allocate certain percentage to each phase or it would be irrelevant based on your overall calculation.

 

Thanks!