Global Change in P6

I am used to P3 and recently shifted to P6. Kindly help me to slove this issue with P6.

I have one user defined column as "Cost" (all numeric values) and I want to put this cost as "Budgeted Cost" by global change for one resouce "0Cost" to produce cash flow. It was much easy in P3 but I am wondering how to deal with it in P6.

R
Raymund de Laza 👤 Member for 16 years 6 months

Malik,

No way in using the Global Change.

I suggest using the Excel File through SDK.

Copy the Budget Cost from the Activity window in P6 and paste it with the Budget Cost in the Resource assignment in Excel File then import into P6.

Hope this will solve the Problem.

I
Ifarhad Malik 👤 Member for 12 years 11 months

Dear Raymund de Laza

My issue is that user defined column has been imported from P3 and is being treated as Activity not Resource by P6. Is there a way to change it globally would solve the whole issue.

Dear Thomas Myers

Any help with multiple global changes or work around would be appreciated.

 

Regards

Imran

A
Alexandre Faulx-Briole 👤 Member for 23 years 4 months

Hello,

Raymond is right: I have missed one important item in my explanations, the UDF has to be created under "Activty Resource Assignments"

Sorry for that mistake,

Alexandre

T
Thomas Myers 👤 Member for 13 years

Alexandre I think you have missed his issue, it is my understanding that if he has "Activity Resource Assignment" as the subject area the way you suggested it working here:

1. Selected Subject Area: Activity Resource Assignments

2. If statement: Resource ID Name = name of your resource

3. Then statement: Budgeted Cost = name of your cost user field ""

Does not work due to the fact he is unbale to select his UDF in the then statement.

Could you not just filter the activities with the resource ID "0Cost" and then apply the global change to the filtered activities only?

There is also probably a work around using mulitple global changes.

Probably no help at all, I would like to know how to do it best as well.

 

Tom

R
Raymund de Laza 👤 Member for 16 years 6 months

Malik,

Make sure you created the UDF under the Categories you wish to. Either in Activities or Activities Resource Assignment.

 

Regards,

A
Alexandre Faulx-Briole 👤 Member for 23 years 4 months

Malik,

I am working with P6V7

My global change works well:

1. Selected Subject Area: Activity Resource Assignments

2. If statement: Resource ID Name = name of your resource

3. Then statement: Budgeted Cost = name of your cost user field

No problem at all

Alexandre

I
Ifarhad Malik 👤 Member for 12 years 11 months

Dear Alex

Thanks for your reply but my problem is that, when i select subject area as "Activities" I can't find Budget Cost in "Then" and when i select subject area as "Activity Resource Assignment" I can't find user defined "Cost" in drop down list of "Then-Middle table of global change".

I need the global change as

IF res = 0Cost

then

Budget cost = COST

where Cost is user difined column filled with numbers

Thanks in advance

A
Alexandre Faulx-Briole 👤 Member for 23 years 4 months

Malik,

Global Change is not very different in P6 than in P3:

"if resource = 0Cost

then Cost = Budgeted Cost"

The "if" statement goes into the topmost panel, the "then" statement goes into the second panel, the bottommost panel stays empty

Alexandre

Forum Sponsor

Top Posters

Josephus Enot
1 posts
Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts