2. If you look at the calcuations tab setting at the Project level on the right under Resource assignments you probally have Recalcuate Actual units and cost when duration % complete changes. This will do this as it should when you progress the schedule. If you dont want this then uncheck that box.
Member for
19 years
Member for19 years
Submitted by Rodel Marasigan on Fri, 2022-02-11 12:44
Primavera (P6) behavior is to spread the cost/ unit to the latest datadate that is why it will keep changing the spread on each timeline. If you wanted to freeze the actual, you have to used the store period performance. You can direct the Power BI to pick-up the data from the TASKFIN table if your source is direct link to P6 Database. If you are using excel as your power bi source using P6 Data, Use the At Completion Cummulative data and create a formula to deduct the previous sum to get the period this week total. Always paste value the previous cut-off date and don't overwrite.
I cannot see your sample as the image is not showing or the link for sample is not working.
My recommendation is checked the setting for % complete type. It is set to duration and the calculation settings for resource assignment is "Recalculate Actual Units and Cost when duration % complete change" is tick then every time your data date change. Duration % complete change, therefore you progress will change. Percent complete type should be set to Physical so your manual update will not be change and remove the tick on "Recalculate Actual Units and Cost when duration % complete change"
Member for
16 years 3 monthsit will only correct itself
it will only correct itself you add the resource again.
The rules that were in effect at the time that you assigned the resource to the activity remain in effect.
If you were to add resources with the new settings then it would not calculate the actuals if you changed the setting.
If you start another project and dont want the actuals to add that way then put the settings the way that I posted them,
Member for
8 years 6 monthsHi Zoltan, I unchecked the
Hi Zoltan, I unchecked the Recalculate Actual Units and Cost when duration % complete changes, the result I got is still the same.
I guess I will stick to the store period performance. Thanks for your suggestion.
Member for
8 years 6 monthsThank you very much Rodel for
Thank you very much Rodel for the suggestion. You are a LEGEND.
Member for
16 years 3 months1. you sould always use store
1. you sould always use store period performance
2. If you look at the calcuations tab setting at the Project level on the right under Resource assignments you probally have Recalcuate Actual units and cost when duration % complete changes. This will do this as it should when you progress the schedule. If you dont want this then uncheck that box.
Member for
19 yearsHi Jegede,Primavera (P6)
Hi Jegede,
Primavera (P6) behavior is to spread the cost/ unit to the latest datadate that is why it will keep changing the spread on each timeline. If you wanted to freeze the actual, you have to used the store period performance. You can direct the Power BI to pick-up the data from the TASKFIN table if your source is direct link to P6 Database. If you are using excel as your power bi source using P6 Data, Use the At Completion Cummulative data and create a formula to deduct the previous sum to get the period this week total. Always paste value the previous cut-off date and don't overwrite.
Member for
8 years 6 monthsHello Rodel,Thank you for
Hello Rodel,
Thank you for your suggestion, I really appreciate it.
I untick the 'Recalculate Actual Units and Cost when duration % complete change' and it is still the same. Below is the case.
[[wysiwyg_imageupload:8068:]]
Member for
19 yearsHi Jegede,I cannot see your
Hi Jegede,
I cannot see your sample as the image is not showing or the link for sample is not working.
My recommendation is checked the setting for % complete type. It is set to duration and the calculation settings for resource assignment is "Recalculate Actual Units and Cost when duration % complete change" is tick then every time your data date change. Duration % complete change, therefore you progress will change. Percent complete type should be set to Physical so your manual update will not be change and remove the tick on "Recalculate Actual Units and Cost when duration % complete change"