MS Project Planned Percentage Complete Vs Actual Percentage complete - Updated Improved version

[@bbcc2020]

What a genius you are! In a space of 15mins, you unravelled a whole semester topic just like a piece of cake. I'm impressed!!

[@niksprojects]

Glad it helped, please subscribe if you haven’t already and share with friends if it helps them too

[@niksprojects]

Would you be interested to learn more on project management from professional PM then checkout www.niksprojectsacademy.com

[@homas7602]

Thanks Nik. It was so helpful. please note that you can summarize all the process in just one single step: Step1: insert field text1, and copy the formula "Format(IIf(Duration>0,IIf(ProjDateDiff(Start,[Status Date])/480>=Val(ProjDurConv([Baseline Duration],pjDays)),Val(ProjDurConv([Baseline Duration],pjDays)),IIf(DateDiff("d",[Baseline Start],[Status Date])[Baseline Start],1,0)),"0%")" into the field formula placeholder. i this way the error from the milestones is also fixed.

[@niksprojects]

Homa S agree, thanks. If you haven’t subscribed to my channel please do so to help grow/ interact with this PM community here.

[@addixon777230]

I do realized that the Actual % Completion tends to be higher than the Planned % Completion (This formula). This is puzzling. Any idea what did I not do right?

[@sandeepsoni8241]

hi Homa I am Getting error on above formula "d" can you please provide solution

[@HeenaSpace]

Actual is greater than Planned even after delay with this formula. Actually all the Planned % Formulas have the same issue. When the Project is Complicated and big. This formulas doesn't work. Can you help me how to fix this? Thanks

[@niksprojects]

Also check out my Project Management Master Class for a 25% discount for KZbin subscribers www.niksprojectsacademy.com

[@cesarmades]

Sir! I was doing a separate project file just to calculate this. You're help is truly appreciated.

[@niksprojects]

Glad it helped

[@ma.ruthamores511]

This is exactly what I am ought to do and has been giving me a headache til today. I'm gonna try this! Thank you!!!

[@niksprojects]

Thanks! Glad it helped

[@DP-xz8xr]

Perfect video. Been trying to write something similar myself for ages and never quite got it working, so this has really helped me out a lot!!!! THANK YOU.

[@niksprojects]

Glad it helped, it’s great to hear good feedback, thanks to you for leaving a comment

[@Ajip-vs8dp]

This video was PERFECTION. Exactly what I needed, very clear, straight to the point, easy to follow. You got my subscription for this one! My question is how to convert the percentage in days

[@niksprojects]

Thanks! glad it helped

[@geckocolado2]

Excellent video! It was so instructive! All my questions were solved! I encourage you to show more your videos!!! It was really hard to find you!

[@niksprojects]

Thanks a lot, I will try to post more often

[@raajkumard]

Very good informative video. 15 mins well spent..

[@niksprojects]

Thank you Sir

[@AlarSouth]

Thanks a lot for your help. this was the only place I could find the answer for my question.

[@niksprojects]

Glad I could help!

[@CoralCobra784]

This video was PERFECTION. Exactly what I needed, very clear, straight to the point, easy to follow. You got my subscription for this one! I am sold.

[@niksprojects]

Thanks a lot Adriel and welcome to the community

[@anony449]

Very True, Nik is great!

[@niksprojects]

@@anony449 Thanks for the encouragement and kind words

[@familyacc946]

thank you so much nik..i had that error and somehow couldnt figure out what is the problem..good to learn in from this video..god bless..

[@niksprojects]

Glad it helped!

[@davidmboko7184]

Very useful, thanks for putting this together. As far as the error, I can't tell you exactly why, but the quotes in "d" are not being copied the font that Project expects, so it considers it a foreign language.

[@niksprojects]

Thanks

[@yelvalycastillo8341]

Your explanation and formulas were so useful ! Thanks!

[@niksprojects]

Glad it helped

[@belvinabenjamin3888]

Hi, my planned % is over 100% for some items, what is the logic behind this and is it normal? some even goes to the negatives in thousands i.e. -4000%

[@bryanliang8784]

Hi Nik, I managed to get the planned %, but the % in % complete is not tally to planned % after I key in the same % in % complete. Would appreciate it if you can explain why. Thanks

[@wendyfakebruneian]

Hi Bryan, I have the same issue with you. Have you resolved this? Can you share with me if you found the solution?

[@Entheogeneticz]

This was very informative! Great work! Definitely in-depth and straight forward.

[@niksprojects]

Thank you!

[@punaschaprakash9471]

Hi Niks, I am interested to know whether we can plot the gantt chart for Planned vs actual in the same ?

[@niksprojects]

I am not sure if we can do a gnatt chart for planned vs actual because these are derived functions / customized columns and not sure if Gnatt will use customized columns.

[@1987Petar]

Maybe you should try by turning on the baseline gantt chart. There you'll have shown baseline (planned) chart and actual chart filled with adequate % completion in the same chart.

[@finality2012]

Sorry nik,could I ask you some thing,does the formula can show cumulative percent complete, because it seems that it just divide whole project to the same measures and when I want to draw s-curve it's like a line not anything like s - curve,and even it's different from cumulative percent complete in task usage view,tnx for ur help

[@adriansteven6940]

This is really useful however, it doesn't work on the summaries when the information is not sequential and overlap. On summaries it just looks at number of days past from the start to the status date and divides it by overall programme length. the does not give a true overall planned % of the tasks below. MS project calculates the %complete for summaries correctly, so there must be a way to replicate this on the summary bars for planned %. Any help greatly appreciated

[@niksprojects]

Thanks! Appreciate the feedback, I will take a look

[@elieokais5841]

@@niksprojects Any Updates on this?

[@carleenrodriguez3226]

Any update?

[@amitdoctor3677]

Hi Nik, can we replace assigned over allocated resources with additional resources when task is in progress? how and do we see work for them after assign?

[@niksprojects]

Hi Amit, under the resource menu on top ribbon , you will see resource sheet button. Click on it to see all assigned resources, update the new resource here and then go back to task and assign the new resource for the task

[@amitdoctor3677]

@@niksprojects Thank you I was done same for assigned new resources, and reload to the task, but when I removed existing resources from in progress(active) task and assigned new replaced resources to the same task work shown 0h, my concern is need to add more same resources with in replacement of over allocated resources. possible for new assigned resources show work in resource usage sheet.

[@ibrahimhaider2937]

Thank you Nik, amazing one!

[@niksprojects]

Glad you liked it!

[@ibrahimhaider2937]

@@niksprojects please keep uploading videos related to TIAs.

[@meisaano]

Thank you so much Sir Niks for your shared knowledge. Really appreciate and helping me lots. Again, thank you so much.

[@niksprojects]

You are welcome! Glad it helped!

[@harshchhibba]

hi nik..its really helpful..jst let me know how the same can be extracted as a report or we copy and past it in excel or word to get d same. i need report on actual and planned progress along wth S curve as line

[@traceygerald7267]

Hi Nik. Thank you for this video. Very helpful. I've followed your steps however still getting Errors on Elapsed Days for some tasks. Any suggestions on what I might be doing wrong / what I need to check further?

[@glenpereira766]

I am also getting those errors for some task under elapsed. Hope Nik can help. Applied to an existing project with baseline.

[@kalilmarleyjr.8919]

Very good !! How can we do to have the cumulative planned percentage to draw the curve of planned cumulative vs completed cumulative ?

[@vishwajeetdesai8533]

Hi,Ideally when & how many Baselines to be created. And secondly how do i get duration variance wrt to current (latest baseline).When i check duration variance its compares with 1st basline.

[@niksprojects]

Just need 1 baseline to be created. Also make sure in the Project tab under Project Information the status date is set to current date. In Step 2 we use the Baseline in the formula as you can see here 6:39 so make sure that you use the correct baseline in the formula if you have multiple baselines or clear the baseline for the entire project (if it's ok) and the set the baseline again.

[@vishwajeetdesai8533]

@@niksprojects Thank you very much for your instant reply. If I want duration variance wrt to latest baseline then what should i do? Please guide

[@rohitgayawal7613]

hi Nik, thats great! What about milestone tasks? Since the duration is 0 it gives an error with this formula. D you have any hack for that?

[@niksprojects]

We can tackle that by adding an additional IF statement to ignore or add specific formulas for milestone tasks. Let me see if I can create a video showing that with an example

[@rohitgayawal7613]

That would be of great help! Thanks

[@nicholaschan3420]

@@niksprojects have you create the video? i have the same issue

[@shaifulnizam340]

@@niksprojects any updated on this

[@rogelioleon7138]

Niks, thanks. great formula. You could make it better by validating the "milestones" using in the field "number 3" the formula IIf(Number2=0,0,Number2/Number1)

[@niksprojects]

Good suggestion, have to test it out in the nested if conditions

[@BrokenAllZ]

Hi Nik, thanks for your videos, have been very helpful. I wanted to know if you can help me with an error, in my case I have tasks that its duration is on days and hours. Do you have a formula that includes these two cases? Thank you!

[@niksprojects]

check out the latest template for download with updated formula - niksprojects.com/product/planned-complete-formula-ms-project-file-template/

[@BrokenAllZ]

@@niksprojects Thanks!!

[@ahmadsalem8168]

That was EMAZING! what will happen if we changed the baseline? Will it take the last one?

[@niksprojects]

Yes it will be based on the latest baseline

[@khanna5433]

This will help to have apple to apple comparison, earlier I used to keep two mpp files one carrying fill in actual data from team members and other updated as per status date

[@niksprojects]

Chetan Khanna agree, it better to have all in one place

[@umairahsallehudin192]

Thank you this videos is life saver!🤩

[@niksprojects]

Glad it helped

[@DarrenChin60Days]

nice, you helped me a lots. gonna show you some token appreciation. thanks

[@niksprojects]

Thanks

[@johnnyb5231]

Love the video. Works great when I do it to individual projects but once I merge them into a Master Project folder as sub-projects, I start getting 0 values in the Durations and Elapsed columns for some of the sub-projects. Having a hard time figuring out why.

[@dialahaidar4763]

The video really helps thank you.. only one thing that the % baseline giving error when dividing 0/0

[@doankienkiet4730]

Hi Nick, thank you for your tutorial , but i having a problem with elapsed day is negative, how can i set all of negative days as "0"

[@lukekerin3933]

Hi Niks Great tutorial followed all of the instruction and works perfectly however when I reduce or increase the duration of a task i get a % in a negative or exceeds 100%. How do I rectify this issue?

[@niksprojects]

Please see if you have set the baseline after making the changes to duration, status date is set correct and let me know if that resolves the issue.

[@lukekerin3933]

@@niksprojects Hi Niks this works however I don't want to continually reset my baseline as it won't give me an accuracy I'm looking for, have you created a formula which will look at the baseline duration and the status date only and any changes to the duration does affect the Duration % Completed. IE if I have a project which has 10 x tasks for a day each and after day 3 this tasks tasks 4 x days to complete. I would like to see the Duration % Completed to indicate tasks 1 - 7 should be 100% and after changing the Day 3 task duration to 4 days the % Completed 1- 3 should be 100%. Hope my request makes sense.

[@frankverabarces803]

@@lukekerin3933 I was about to question the same thing on this video. It seems very few people have realised that this is not applicable to all cases. Good job!

[@02civilmubasher]

Sir, this calculation is based on days not manhours. If we want to do calculcations based upon elapsed manhours, what will be the formulae???

[@niksprojects]

I haven’t thought about it in detail, but just thinking out loud , isn’t it possible to convert man hours to days, meaning If the task takes 24 man hours then it is equivalent to 3 days (24 div by 8). Can you use that way or is that too much of a hassle?

[@02civilmubasher]

@@niksprojects I think, it is not too simple, because, this formula will not work in that case. Need to create another formula.....

[@evansy]

Thank you, absolutely class!

[@niksprojects]

Glad it was helpful!

[@jayveedignos6840]

Hi, how do you eliminate calculating the milestone in the programme. It showing error on the table

[@niksprojects]

You can do that by IIF condition, if milestone then display 0 before applying the rest of the calculations.

[@kobiecoetzee1660]

A great learning, thank you so much. NOW, how do I show this (% Comp vs Planned % Comp) in a S-curve?

[@phamnam4819]

Hi Niks, Thanks for a great video, It is very helpfull. I just wonder that for example: Actual % complete is 70% and Planned % complete is 60% then we assess the schedule is ahead? If there are some critical tasks in this case were delayed? and free slack and total slack will not impact on total schedule of project. Could you please advise in this case? Thanks a lot.

[@niksprojects]

Hi @Pham Nam, you are welcome! The actual % is something that we type in manually based on the progress, so if the team is stating that they have completed 70% then yes that particular task is ahead of schedule as the planned % calculate shows that it is only 60%. If you want to see if any critical tasks are delayed then you can filter in the gnatt to show only critical tasks and then look at the planned and actual % complete. Total slack show that how many days you have in slack / as buffer if delayed will not delay the project itself.

[@pranav7777777]

Hello Nik, I tried your Planned % Completion formulae, but when we start tracking the progress of the project, 'Duration in days' is changing with respect to 'Actual Duration' in Tracking Table, but not the Baseline Duration. As a result my 'Planned % Complete' comes out to be wrong. Please tell me what change is to be done in the formulae.

[@niksprojects]

Hi Pranav - In Step 2 we are using the baseline duration and comparing against the project status date. See the formula here Formula: IIf(ProjDateDiff(Start,[Status Date])/480>=Val(ProjDurConv([Baseline Duration],pjDays)),Val(ProjDurConv([Baseline Duration],pjDays)),IIf(DateDiff(“d”,[Baseline Start],[Status Date])

[@pranav7777777]

​@@niksprojects Yes Nik, I verified the formula, it states Baseline Start and Duration. But there is some issue with Baseline Finish or Actual Finish. When I put the Act Finish = BL Finish, the Planned % Compl comes out to be 100%. However, when I put Act Finish < BL Finish, P%C comes out to be more than 100%. Also, vice versa happens with Act Finish > BL Finish. Could you kindly check this issue in the Tracking Table, and get back to us. Thankyou.

[@niksprojects]

I will have to take a look 👀, will post here if I see what’s the issue or recreate the problem

[@silver2sid]

Ho do you find difference of planned and actual progress percentages??

[@niksprojects]

You should be able to add a custom number column and then use a formula to do the calculation (substract) function

[@MrShahzaib7]

Can you tell me how can we make s-curve or bar chart data from these number roaws?

[@rafaelroberto933]

Excellent video!!! Exactly what I was looking for!!!

[@niksprojects]

Rafael Roberto glad it helped! Thanks for watching

[@swiftandsimple1983]

Could you please show me what the formula should be in step 2 if the duration is in hours. Still cant get the elapsed hours into hours which still seems to be showing in days.

[@niksprojects]

I convert in to days by multiplying 480 = 8 hours in a day X 60 minutes. So if you don’t want to convert in to days then try multiplying by just 60 to convert minutes in to hours in that step

[@swiftandsimple1983]

@@niksprojects Thanks.. finally got it

[@niksprojects]

@@swiftandsimple1983 great!

[@talhamunir827]

Hi Nik, Its really helpful. I want to know that every time when i have to update the progress, will i repeat the same procedure everytime???

[@karlernstbuddenbrock371]

What is the "/480" for in the formula?

[@niksprojects]

It is to convert product days in to minutes there are 8 hours a day which means 480 minutes

[@lumthegreat]

Hi Niks, why does my elapsed days still showed 0, i had complied all the steps. after updating the status date it still showed 0. please assist tq

[@niksprojects]

You can download the updated template with new formula here - niksprojects.com/product/planned-complete-formula-ms-project-file-template/

[@gmartinez77]

Great video, simple and clear. Tks

[@niksprojects]

Thanks 🙏

[@adityaduttapmp6394]

Sir i am getting error on last column(planned%complete), retried for several times,baseline already set but didn't helped,please help

[@paulwu3598]

Hi there, What happens if you have multiple baselines saved? How do you pick the baseline that you want?

[@niksprojects]

we can always update the formula to use baseline1, baseline2 etc. not tried out but I am sure it can be done.

[@ricardohernandezsierra7818]

hello, your videos is ready good, i need to create an s-curve. can you show how to create an S-curve based on % complete

[@saadullahbugti6566]

thanks dear your video solved my big problem

[@niksprojects]

Thanks 🙏, glad it helped

[@saadullahbugti6566]

sir please make a vadio of s curve of percentage planned and percentage completed

[@saadullahbugti6566]

s curve of same video

[@quintinpotgieter2695]

Hi Nik. Firstly, thank you for a very informative video. I see many people have had the same problem I am having - the 0,0, section of the 2nd formula keeps saying error - despite retyping it and then pressing "okay"... Please could you assist with what could be causing this error and how to correct this... There have been no responses to the others who have raised this same query??

[@niksprojects]

I have updated the formula and is working on recording the tutorial, will try to share it in a few days. It’s working fine for me including for the milestone tasks. I think this time I will upload the Project file on to my website itself to download for a small price $4.99 if for some reason the tutorial and instructions sharing via the video is not working out, this way the users can download a local copy which already has the working formula

[@taufiq270674]

Thanks its very helpful May I ask you, how to use those custom field in Report? ... Thank you

[@taufiq270674]

The custom field such as Number1 and Text1 cannot shown if using "Time" for "Select Category"🙏

[@chedusaronakula4215]

hey Niks you video is helpful but i have a question. i get -%(negative values) what might be the problem? and also what happens if you re baseline your schedule.

[@natashamasson6028]

Sir, thank you very much for a well facilitated and designed tutorial. I am still experiencing issues with Step 2 formula. After correcting the "d", there is another syntax issues in the last segment:

[@niksprojects]

check out the latest template for download with updated formula - niksprojects.com/product/planned-complete-formula-ms-project-file-template/

[@raththai6015]

Hello sir, Could you share us how to calculate ahead or delay in percentage and in days?

[@nutchpthn186]

Hi Greeting from Thailand!! I already followed your instruction. However, when I update the status date the Elapsed days still not show the number. Do you have any recommend for this isse? Thank you in advance.

[@curiousambitions]

Hi there! Thanks for the tutorial - I'm finding that % Complete and Planned % complete aren't rolling up to the same percentages even if the sub-tasks have the same % complete. Hope you can help!

[@niksprojects]

the planned % complete is based on the project's baseline dates vs teh % completed is what you would type in manually, so it won't be exactly the same.

[@pranav7777777]

@@niksprojects I am facing the same problem Nik. I agree we type the % Compl manually, but we get some values if we change the status date and then click on Update Project as on mentioned status. It automatically gives us the % complete values which were planned. The individual tasks' percentage completion calculated by this method is same as your Planned % Complete method, however, the summary tasks % complete and Planned % Complete are not matching, as stated by Niki Non. Kindly look into this issue.

[@244pam]

are you giving training on Ms project

[@niksprojects]

I am not , but if you have a specific question then I can answer it via comment or thru a video

[@civilengineering-malayalam6770]

Great video...Your video is very practical which is useful for practical applications...I am wondering that how you made the formulas..From India

[@niksprojects]

Thanks Sujith. It was lot of research, trial and error , iterations to arrive at the current formula. There is still room for improvement to make it work for the milestones and summary tasks as well. Not getting enough time to refine further, but will get there soon

[@khalidzamanueconsultantkpk826]

Dear Sir, Your way of teaching is humble, and appreciated. I follow you steps by steps on the above tutorial, i face a bid hurdles during calculation of Elapsed Days, Formula is okay and applied but no counts the days in column just show zero number overall, your correction is indeed. Regards

[@johnmantz4559]

Can we use these formulas even if the tasks are setted manually without predecessors?

[@PushpaPrabhath]

Hi How can we make a weightages for measure the physical progress correctly (Considering work progress and Duration)

[@silmen92]

Hi thanks a lot for the tutorial! It works! But, i have an error for milestone task that has 0 days. My Planned % Complete showing error and understandably so because any number cannot divide by 0. So what should i do to tweak the formula? Thankssss!

[@niksprojects]

It’s a complex formula to take care of the milestone issue and is error prone, so I tweaked the logic completely and using duration- check out the link here niksprojects.com/product/planned-complete-formula-ms-project-file-template/

[@silmen92]

@@niksprojects tq! Will check it out 👍👍👍

[@Denniskovalev]

Hi Niks, thanks a lot for this, but if I change status date sometimes it gives me negative % complete as elapsed days are negative. What can I do to solve this. Please respond if you have time

[@niksprojects]

check out the latest template for download with updated formula - niksprojects.com/product/planned-complete-formula-ms-project-file-template/

[@luiscandeias3374]

Great video, can you tell if it’s possible to include that information in the timeline?

[@niksprojects]

you can right click a task and click "Add to Timeline" from the menu you get when you right click

[@danielstraus6424]

That is impressive! Thank you very much!! Do you know if it would be possible to do that with work instead of duration? I am trying to adjust the formulas to convert the work into days and follow the same idea, but so far no success doing it for the formula in Step 2 (I tried changing "Baseline Duration" to "Baseline Work" but there is more to be done, not getting the right number yet).

[@thachthanhbinh]

Hi Nick, am getting an error on step 2 formular. It highlights ProjDateDiff. I tried retyping but I get the same error.

[@fhynthiazienbobby2986]

Hi Nik, 1 question. How to track & view the scheduled/planned budget by month on Microsoft Project?

[@muhammedhikmet394]

Thanks for good explaining the clear steps, there is just an error occurred at ((% complete)) it show me 0 percent for all tasks!! although changing the status date but still 0%??!! can you kind advise... Thanks in advanced... M.Hikmet (UNDP's resident Eng.)

[@jesusquevedo383]

Hi Mr, Excellent video, works! I have a doubt with the formula in the step 3, why 480? I do some test and if I change from 480 to 960 the % change if how was divided between 2, I have a projec with 524 days of duration, use the same formula with 480 or can I change this value for 524 (duration of my project) thanks

[@niksprojects]

480 is to convert the days hours (8hours) in to minutes which is required for the formula. I have updated the formula completely and now it works for the summary level tasks and milestone without giving division by 0 error. It is available for download for a minimal fee $4.99 . If interested you can purchase from here niksprojects.com/product/planned-complete-formula-ms-project-file-template/

[@NoelStalker]

this was very helpful. Thank you!

[@niksprojects]

You are welcome

[@faraimwashita255]

Hello Nik, how do you add the text field to the report. I am want to my dashboard to show planned % complete v actual % complete

[@hafizulehsanhassan6226]

Hi Nik, sorry to ask, may i know what is 480 represent for in your formula

[@niksprojects]

480 is number of minutes in a day (8 hour day) i.e 8 hr X 60 minutes = 480 minutes. Project uses minutes for this calculation

[@hafizulehsanhassan6226]

@@niksprojects thanks for the explanation Nik 👍

[@nassernusair]

Does this work if new tasks were added that were not part of the baseline ? if it doesn't how it can be done

[@stevewillis2132]

Hi Nick really useful..>Why am I getting the following result of 833% 'planned' though when my activity is better than baseline?

[@amirulhafiz1434]

tq sir, u saved my life

[@niksprojects]

Thanks

[@hasithasandaruwanvidanapat1876]

hey Nick, is it ok to update actual dates of start and finish dates in project tracking ? or we just need to manually update the %complete column without changing the actual start and finish dates?

[@niksprojects]

hasitha sandaruwan vidanapathirana hi, the actual start and finish dates will be updated as you set predecessors. % complete column should be manually updated to reflect the actuals

[@ashleighbarnwell4688]

When i enter forluma into "Step 2". I get an error with the "d" reference in the last part of formula. Should this be referencing a specific column?

[@TLYRIDER]

Ashleigh Barnwell hi, it’s an issue with MS project copy paste. Just delete all the “d” in the formula where you are getting error and re-type back in and it should work

[@niksprojects]

I just replied with my other account (TLY Rider) let me know if it resolves your issue

[@brisonpinto1314]

Hello, the planned % changes when I unlink tasks. What can i do? Among a set of 8 tasks, one of the task is independent of the remaining.

[@michaelhaig3592]

for the elapsed days formula I get the same error on the "d" and then when retype it clears but then it gives me an error on the 0,0, portion on the formula not matter what I try retyping this it does not correct so it does not accept the formula? any advice?

[@hanzreyes2854]

Hi Niks, why is it my schedule stay shows delays even thou all my task are on schedule and a bit ahead to the schedule and the rest of the tasks are future tasks status? Appreciated if there is explanation for this and how to solve this. Thanks.

[@niksprojects]

Can you check if you have multiple baselines in the project, if so I am guessing that’s causing it and you may want to use the right baseline in the formula and also check if you are setting the status date under project information tab correctly

[@znahseyer8685]

@@niksprojects Its still me different account only. Btw, Status date are in order, I've clear baseline and re-set baseline for entire project, its still the same. Even though my actual progress same as schedule, but yet its still shows delays, This is almost perfect, if the actual VS schedule are reporting/summarizing correctly....Headache and I cannot used this for report : (

[@znahseyer8685]

@@niksprojects Hi Niks, I manage to solve my problem already, somehow in your formula for Number2 (elapsed days) I changed the 480 to 600 (I quest 10hrs x 60mins = 600) & your formula works perfectly now and I can used this now in my reporting & presentation. However, I don’t know why it works??, can you explain me why it works and/or beside changing the 480 to 600, is there any other way or other setting I can do if I wish to maintain the 480 so that your formula still works. Thanks very much!!!

[@niksprojects]

@@znahseyer8685 480 is just converting the 8hr work in to minutes 8hr X 60 minutes = 480 Minutes. So if you have 10 Hr work day you are good to use 600 instead of 480. It's just that the formula needs the amount in Minutes. Thats all.

[@SashaRamoutar]

Great Tutorial!! - I have a question - should or rather, can I do this on a Master Schedule with the Sub Projects already pulled in, or would it be better to complete this on each individual Sub Project Schedule first and then pull those into it in the Master Schedule? Hoping to get your guidance on this!!!

[@niksprojects]

You can do it either way both approach should work

[@SashaRamoutar]

@@niksprojects thanks!!

[@SashaRamoutar]

@@niksprojects I have another question please: What is the reason for the Value of 480 in the Elapse days formula?

[@SashaRamoutar]

Hi, can you confirm please?

[@niksprojects]

Sasha Ramoutar 480 is converting days in to minutes as that’s how the MS project store info (8 hrs multiplied by 60 = 480)

[@didapoal]

Hi, why is giving an error on "pjdays"? Val(ProjDurConv(Duration, pjdays))

[@niksprojects]

See if you have the duration updated for all tasks in your project. Also check the project start date and status date is set, That may be causing the issue if any of those dates are not set.

[@nardsteodosio8914]

I think the reason why there is an error after pasting the formula from the webpage is because of the different ascci or character code for the double quotes when rendered on the webpage as opposed to its ascii designation when pasted in MS Proj..just my thought..anyway, for the planned % (number 3), why not incorporate the 4th formula into it?

[@stupadesigns7882]

Thanks nik. How can I make percentage plan weekly in ms project..?.I need to draw a s curve between percentage plan weekly vs percentage completed can you help me ?

[@فارسماس]

What does (480) mean in an Elapsed days equation?

[@فارسماس]

@Niks Projects

[@niksprojects]

480 is just converting the 8 hr day in to minutes. 8*60=480. This needs to be done because in MS Project the details are stored in Minutes

[@niksprojects]

Hope that clarified your question

[@فارسماس]

Thanks Mr. Niks .. I have difficulty understanding the Elapsed day equation Can you explain it ? My Greeting & Respect ☺️

[@niksprojects]

@@فارسماس Elapsed days means the number of days that has passed from the start date of that particular task. For example if a task is planned to start on Dec 19 Thursday and if today is Dec 20 Friday then the elaspsed days is 1day. This is basically required to find out if we are on time, behind or ahead of schedule.

[@TravisLyons925]

Hello! Great video, very clear and informative. I am curious if you know of a way to use a date set a number of days in the future for this field? What I am trying to do is create a field that gives a planned % complete 30d ahead of the project status date (and also 60, 90). This is a report being requested by leadership of my institution, and we have many many projects to report on. Thank you for your help!

[@niksprojects]

I believe you can do that by setting the status date. You can project information and set the status date to 30D, 60d ahead and formula should readjust

[@TravisLyons925]

​@@niksprojects Yes, using the status date is how we've been reporting on expectations for completion. We use Power BI to generate reports and can reference % complete in MS Project Server... But my hope is to have multiple data fields present to have those values auto-generated as dates change. I alone have 50+ ongoing projects, and individually opening each one to get predictive data is very tedious.

[@saidnemr5473]

HI NIKS : I Have proplem in ms pjct. the owner decide to cancel un cash activities so if i want to make equation such as planned value=Bcws/baseline cost the result for uncash tasks =error as BL.cost =0 Iwant to ignore error how?

[@niksprojects]

You can ignore the error by adding an IF condition, I am not sure if MS Project has function similar to excel like IFERROR or not , you can check in the MS project online documents. I will also take a look and let you know if I find any

[@saidnemr5473]

@@niksprojects I check there is no iferror in ms project

[@niksprojects]

Said Nemr ok

[@theashishorbit]

Hi Nik, With formulae i still getting error with milestone tasks. Can u suggest what can be done for that ?

[@lokeshkoutge7633]

Nik May thanks for uploading this video, I'm facing an Issue while monitoring the schedule. The milestone activities are not getting updated the % planned progress. How to resolve it, if you are having an solution for it pleas do let me know. Many thanks in advance.

[@niksprojects]

I had to revamp the full formula and I have posted on my website if you would like to download for a small fees. niksprojects.com/product/planned-complete-formula-ms-project-file-template/

[@engr.roheel9525]

Hi Nick,I hope you are fine...I have problem,that when I insert column of duration in days after assigning baseline,my duration does not show in WBS,where may be sth wrong in my working please.

[@eml2153]

Hello Nik, I have a question, where is the value pjDays in field or function? I can't find it. Please could you help me? thank you so much

[@niksprojects]

pjDays is Project Days. MS Project convert the duration in to days by using that formula

[@robincoutinho3334]

great video 👍 i want to calculate progress based on weightage instead of duration… can you guide on this ?

[@saravanamuthu1986]

How the actual percentage automatically arrived in this sheet?

[@niksprojects]

Actual % complete is a manual entry that needs to be typed in and not auto calculated