Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

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.

Assign a Formula in User Defined Field

2 replies [Last post]
Sun, 2007-04-01 22:03
Daniel Situmorang
User offline. Last seen 13 years 22 weeks ago. Offline
Joined: 4 Sep 2003
Posts: 9
Groups: None
Hi,
Is there any possibility in P5 where we can fill in a formula in a user defined field?
Let’s say:
- column A is % planned
- column B is % complete
- column C (user defined field) is % variance which is A - B
Thanks.

dts
Top

Replies

Tue, 2007-04-17 03:22
#1
John Murray
User offline. Last seen 17 years 5 days ago. Offline
Joined: 15 Apr 2007
Posts: 4
Groups: None
Good info Karim,
I have been cought out with this when running a global change it only works on filtered activities (so check your filter). If your activity is not included it will retain the old User Value !!! Be careful !!!

Cheers
John
Top
Mon, 2007-04-02 00:17
#2
Karim Mounir
User offline. Last seen 9 years 36 weeks ago. Offline
Joined: 5 Apr 2006
Posts: 314
Groups: None
Hi Daniel,

By using global change u can define the value of a "User defined field".

1. Click on "Tools" --> "Global Change", click on "New", in the "Select subject area" select "Activities" (if u want to modify resources assignment choose Activity Resource Assignment).
2. Now in the "If" field choose a criteria to apply (or otherwise if u want to apply the statement on all of the activities leave it blank).
3. In the "Then" field and under "Parameter" choose your "User defined field" that u created, in the first "Parameter/Value" choose the % planned, in the "Operator" field choose (-), & finally in the second "Parameter/Value" choose % complete.
4. After that click on "Change" on the left pane, after reviewing the "Old value" VS. the "New value" click on "Commit Changes" or "Cancel Changes".
5. U can show the new "User Defined Field" in the layout by clicking on "Columns" icon and then choosing "User Defined" list and selecting your "User Defined Field" name.

HTH.

Regards,
Karim
Top