to do this exercise, create a UDF as number. export P6 to excel and then populate the new UDF column with a formula (as number, not %). and import it back to P6, you can see the contribution of each activity against the overall budget.
I believe that for the UDF import/export process, P6 is not supporting it with % figure, but only as a number.
Kannan
Member for
16 years 3 months
Member for16 years4 months
Submitted by Zoltan Palffy on Mon, 2019-07-29 14:30
Hi David thanks for this update. Thats exactly what I was avoiding to do. Honestly I thought there was an automated way of doing this. This problem was whacked my head so good. I felt like throwing the pc over the balcony.
No automatic way of doing this. You would need to manually edit a Global Change script with the total project cost, so that you can calculate each activities proportion of it. Every time any budget cost changes, you would need to edoit the script and run it.
Member for
17 years 4 monthsRodney,to do this exercise,
Rodney,
to do this exercise, create a UDF as number. export P6 to excel and then populate the new UDF column with a formula (as number, not %). and import it back to P6, you can see the contribution of each activity against the overall budget.
I believe that for the UDF import/export process, P6 is not supporting it with % figure, but only as a number.
Kannan
Member for
16 years 3 monthsadd a udf and then run a
add a udf and then run a global change to do the math to get the percentage.
Member for
21 yearsRodney,I think you will find
Rodney,
I think you will find that niether you or the actual PC is responsible for this charming oversight......
Member for
6 years 3 monthsHi David thanks for this
Hi David thanks for this update. Thats exactly what I was avoiding to do. Honestly I thought there was an automated way of doing this. This problem was whacked my head so good. I felt like throwing the pc over the balcony.
Member for
21 yearsRodney,No automatic way of
Rodney,
No automatic way of doing this. You would need to manually edit a Global Change script with the total project cost, so that you can calculate each activities proportion of it. Every time any budget cost changes, you would need to edoit the script and run it.