Forum Sponsor:

An innovation in P6 Professional training from RPCuk in partnership with Oracle. All the topics that matter to you in workshops customised to your role and industry.  Now get superior training value when you book our Blended Learning Bundle. Learn more here.

Viewer for .xer, xml and xls schedule files Schedule Reader™Free Trial

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Activity cost as a percentage of the Project Budget Cost

5 replies [Last post]
Rodney Atuhaire
User offline. Last seen 3 weeks 23 hours ago. Offline
Joined: 29 Jul 2019
Posts: 3
Groups: None

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. 

Replies

Kannan CP
User offline. Last seen 2 days 22 hours ago. Offline
Joined: 12 Jun 2008
Posts: 278
Groups: None

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

Zoltan Palffy
User offline. Last seen 22 hours 41 min ago. Offline
Joined: 13 Jul 2009
Posts: 2377
Groups: None

add a udf and then run a global change to do the math to get the percentage.

David Kelly
User offline. Last seen 3 weeks 1 day ago. Offline
Joined: 19 Oct 2004
Posts: 563

Rodney,

I think you will find that niether you or the actual PC is responsible for this charming oversight......

Rodney Atuhaire
User offline. Last seen 3 weeks 23 hours ago. Offline
Joined: 29 Jul 2019
Posts: 3
Groups: None

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. 

David Kelly
User offline. Last seen 3 weeks 1 day ago. Offline
Joined: 19 Oct 2004
Posts: 563

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.