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.

Using UDFs how can I put percentage value in P6 r18.8

5 replies [Last post]
Bonsio Noval PMP
User offline. Last seen 1 hour 27 min ago. Offline
Joined: 30 Jan 2017
Posts: 5

Dear Expert and P6 practitioner, 

I want to show some percentage using UDF, I tried Global change but it yield up only decimal points.

And the sum up on wbs level with wrong value.

Please I need help.

Thanks...

Replies

Zoltan Palffy
User offline. Last seen 17 hours 1 min ago. Offline
Joined: 13 Jul 2009
Posts: 2573
Groups: None

I dotn understand that it is working at the activity level but not the wbs level.

All work is at the actvity level WBS is just a way of grouping your avtivities

you must understand for wbs that in order to perform an earned value analysis, you must specify two calculation techniques. These techniques apply to activities that are currently in progress. The first technique is used to calculate an activity's percent complete. The second technique is used to calculate an activity's Estimate to Complete (ETC). A set of options is provided for both of these techniques, and you can set these options for each WBS element.

The fundamental earned value parameters used to calculate an activity's Estimate to Complete are: Earned Value Cost; Budget At Completion (BAC); Planned Value Cost; and, Actual Cost. You can derive an activity's Estimate to Complete and other earned value indexes from these parameters.

If you are the administrator for your organization, you can specify default earned value techniques for WBS elements.

Bonsio Noval PMP
User offline. Last seen 1 hour 27 min ago. Offline
Joined: 30 Jan 2017
Posts: 5

Sir, if I choose Activity resource assignment, in the drop-down list, there is no selection for

Earn value Labor Units

Zoltan Palffy
User offline. Last seen 17 hours 1 min ago. Offline
Joined: 13 Jul 2009
Posts: 2573
Groups: None

since you are dealing with resource types of fields you must change the subject type to Avtivity Respurce Assignments

Bonsio Noval PMP
User offline. Last seen 1 hour 27 min ago. Offline
Joined: 30 Jan 2017
Posts: 5

Thank you Sir Zoltan Palffy, for your response

        I have created a global change

under Select Subject Area I choose Activities then in parameters

Where earn value labor units is greater than 0
then UDF = earn value labor units/Actual labor units

And UDF = UDF * 100

then select change >>>> Commit Changes

however, this working equation were successfully yield a correct result on Activity level only but on the WBS level it does not.

Zoltan Palffy
User offline. Last seen 17 hours 1 min ago. Offline
Joined: 13 Jul 2009
Posts: 2573
Groups: None

use the global change and multiply by 100 in the global change 

also make sure that you have the correct type of UDF 

they can be associtated with the activity or the resource assignmnets

also check the data type of the udf they can be text, cost finish date, indicator,integer, number or start date