We've updated the ServiceNow Community Code of Conduct, adding guidelines around AI usage, professionalism, and content violations. Read more

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

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

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

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!