Skip to content

Custom Field Formula in P6

Antonio TeixeiraMember for 19 years 5 months
Created
5
3
0
In MS Project, i make a custom field within formula (IIf([Work]<>0;([Actual Work]/[Work])*100;0)) to show percent column (% WBS). How can i make it in P6? (show a percentage column based on budgeted unit)

Thanks, Junior.

5 replies

Oldest first
  1. 0
    Dieter Wambach ·
    Antonio

    "The percent complete of units for all labor and nonlabor resources assigned to the activity. Computed as Actual Units / At Completion Units * 100. Always in the range 0 to 100."
    This was taken from the "Hint Help" for "Units %-complete. No need for a UDF.

    Regards
    Dieter
  2. 0
    Antonio Teixeira ·
    Dieter, thanks for u reply.

    Ok. this field (Units %-complete) show the Real % based on unit. However, i need show the weight of WBS. I’ve to calculate: ( budgeted unit / total budgeted unit (in MS Project i input it manually))*100.

    I need to know about the activity in terms of working on the project.
  3. 0
    Dieter Wambach ·
    Antonio

    Sorry, your last sentence I don’t understand.

    In Primavera you have many possibilities for %-complete. Study this part within the reference manual or activate the "Hint Help". There you find the formula each field is calculated.

    Units %-complete is calculated the way you described.

    Regards

    Dieter

  4. 0
    Mohammadreza Mostafavi ·

    if we use physical % not u %

    if we use physical % not u % and we just wanna the calculate A.M formula what should we do?

  5. 0
    Khaja Sharief ·

    In primavera you have can do

    In primavera you have can do it through Global Change, select the custom filed and you can assign the formula. Unlike in MS Project, here you have to run Global change every you want to have the custom field updated. i.e. when ever you  update the actual work you should also run the global change to reflect the updates into the custom field. 

Log in or join to reply

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

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