Skip to content
ProjectControls.com
Oracle Primavera - PM6

Activity cost as a percentage of the Project Budget Cost

In the Open Standard
Rodney AtuhaireMember for 7 years 2 months
Created
5
3
0

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. 

Save Follow Follow forum Report
Reply New topic

5 replies

Oldest first
  1. 0
    David Kelly ·
    #1

    Rodney,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.

    Report
  2. 0
    Rodney Atuhaire ·
    #2

    Hi 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. 

    Report
  3. 0
    David Kelly ·
    #3

    Rodney,I think you will find

    Rodney,

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

    Report
  4. 0
    Zoltan Palffy ·
    #4

    add a udf and then run a

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

    Report
  5. 0
    Kannan CP ·
    #5

    Rodney,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

    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?