Thanks for that, I figured earlier that if I zeroed it then the units % complete would work. I've been trying it on some test projects and thank you for confirming I wasn't chasing rainbows with that method.
Kind regards,
Thom
Member for
19 years
Member for19 years
Submitted by Rodel Marasigan on Tue, 2022-03-01 15:40
Unit % complete formula is "Actua Unit / At Completion Units * 100". Therefore when you used Unit % complete calculate actual units you have to follow the correct process. See sample below:
Say:
100 = Budgeted Labor Unit
100 = At Completion Labor Unit
0 = Actual Unit
1) If Actual Unit = 0 and you enter Unit % Complete = 20 then P6 will Calculate Unit % Complete = 20/100*100 = 20 Actual Unit
2) Now for the next update, Actual Unit already have 20 therefore the calculation of Units % Complete is always ""Actua Unit / At Completion Units * 100" . If you enter 30 Unit % Complete, the Actual unit will not change and will remain 20 units and P6 will calculate Unit % Complete using the formula which equivalent to 20*100/30 = 66.6667 At completion Unit = 30 Unit % Complete = 20 Acutal Units/ 66.6667 At completion Unit * 100.
Therefore Unit % complete is not the correct way of updating Actual Unit and it's the other way around. In order to update the Actual unit based on Unit % Complete once there is already have Actual Units you have to return to 0 out the Actual Unit to used Unit % Complete as basis of Actual Unit.
The simple step if Actual Unit is already have actuals is:
1) make sure Budgeted Unit = At Completion Unit (labor or non-labor which ever is you are using)
2) Zero out the Actual unit by entering 0 to Actual Unit or zero out Unit % Complete in Columns on Activity Level and not on the resource tab - not recommended if using multiple resources as other resources will be zero out also)
3) Enter the correct Unit % Complete once Actual Units is already zero and your Actual Unit will have Actual Units based on Unit % Complete * At Completion Unit.
Member for
19 years 1 month
Member for19 years1 month
Submitted by Thomas Nicholson on Tue, 2022-03-01 13:04
Tried different things like that, but it only ever changes the remaining duration and doesn't touch the actuals.
I'm going through the resources on an activity to update them and the "units % complete" does nothing to the actuals.
Am I missing something fundamental? If my budgeted units are 180 then my putting 50% in the units % complete should give me an actual of 90 and a remaining of 90, it correctly changes the remaining but leaves the actual at zero. So I have to go through each resource manually correcting the actual units.
Member for
16 years 3 months
Member for16 years4 months
Submitted by Zoltan Palffy on Tue, 2022-03-01 12:32
Member for
16 years 3 monthsduration % complete triggers
duration % complete triggers the actual units.
change the % complete type to duration % complete and it wil update
also duration type to fixed duration & units
Member for
19 years 1 monthHi Rodel, Thanks for that, I
Hi Rodel,
Thanks for that, I figured earlier that if I zeroed it then the units % complete would work. I've been trying it on some test projects and thank you for confirming I wasn't chasing rainbows with that method.
Kind regards,
Thom
Member for
19 yearsHi Thomas,Unit % complete
Hi Thomas,
Unit % complete formula is "Actua Unit / At Completion Units * 100". Therefore when you used Unit % complete calculate actual units you have to follow the correct process. See sample below:
Say:
100 = Budgeted Labor Unit
100 = At Completion Labor Unit
0 = Actual Unit
1) If Actual Unit = 0 and you enter Unit % Complete = 20 then P6 will Calculate Unit % Complete = 20/100*100 = 20 Actual Unit
2) Now for the next update, Actual Unit already have 20 therefore the calculation of Units % Complete is always ""Actua Unit / At Completion Units * 100" . If you enter 30 Unit % Complete, the Actual unit will not change and will remain 20 units and P6 will calculate Unit % Complete using the formula which equivalent to 20*100/30 = 66.6667 At completion Unit = 30 Unit % Complete = 20 Acutal Units/ 66.6667 At completion Unit * 100.
Therefore Unit % complete is not the correct way of updating Actual Unit and it's the other way around. In order to update the Actual unit based on Unit % Complete once there is already have Actual Units you have to return to 0 out the Actual Unit to used Unit % Complete as basis of Actual Unit.
The simple step if Actual Unit is already have actuals is:
1) make sure Budgeted Unit = At Completion Unit (labor or non-labor which ever is you are using)
2) Zero out the Actual unit by entering 0 to Actual Unit or zero out Unit % Complete in Columns on Activity Level and not on the resource tab - not recommended if using multiple resources as other resources will be zero out also)
3) Enter the correct Unit % Complete once Actual Units is already zero and your Actual Unit will have Actual Units based on Unit % Complete * At Completion Unit.
Member for
19 years 1 monthHi Zoltan, Tried different
Hi Zoltan,
Tried different things like that, but it only ever changes the remaining duration and doesn't touch the actuals.
I'm going through the resources on an activity to update them and the "units % complete" does nothing to the actuals.
Am I missing something fundamental? If my budgeted units are 180 then my putting 50% in the units % complete should give me an actual of 90 and a remaining of 90, it correctly changes the remaining but leaves the actual at zero. So I have to go through each resource manually correcting the actual units.
Member for
16 years 3 monthsMy quess is that you are
My quess is that you are using physical % complete you need to use duration % complete to update the actual units
make a global change
where physical % complete is greather than 0
then duration % complete = physical % complete