Hi guys, I would like to express an activity cost as a percentage of the project budget cost. For example
Project A - Total Cost is $5000
Project A has numerous activities and I would like a Column that expresses the Cost of the Activities as a percentage of Project A total cost.
For example if Activity 1 within Project A has a total budget cost of say 1000. I would like a column that shows Cost % Budge of Activity 1 as 20%.
I tried using the column "Cost % of Budget" and it was only giving me Zero % ages for every activity.
I would appreciate any form of assistance with this request.
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
add a udf and then run a global change to do the math to get the percentage.
Rodney,
I think you will find that niether you or the actual PC is responsible for this charming oversight......
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.
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.