Project Percentage Calculation

[psierra]

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

[Namita Mishra]

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 · Accepted solution]

if below are the tasks in a project 

Worked duration for each task can be calculated through below formula

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

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 %

[psierra]

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

Regards

[prasannaposetty]

Hi Sierra,

In ServiceNow OOB, there is no logic available for Percent Complete. Please find the below link which explains about Time cards and Percent Complete.

https://community.servicenow.com/community?id=community_question&sys_id=bc1a4769db5cdbc01dcaf3231f96...

However you can build your own logic to auto populate Percent complete when a time card is approved. Below are 2 ways of doing it:

1. Project Percent Complete = get “Sum of all Project Tasks Percent Complete”, and dividing the sum by “Number of Project Tasks” for the Project
2. Project Percent Complete = “Actual Effort” of the project divided by “Planned Effort” of the project and multiplying by 100

But i prefer the 2nd method as it is more accurate, see below an example of both methods

Please mark Correct/Helpful if this answers your question. 

Regards,

Prasanna Posetty