Skip to content

How can i store the sum of OD in a variable ?

Nilo SouzaMember for 21 years 2 months
Created
14
3
0
Help me, please. How can i create a variable that is available to store the sum of original duration like the comand TOTAL in organize ? I want to put this variable in global change to relationship sum of original duration with the phase of project.

14 replies

Oldest first
  1. 0
    Mary JoAnn ·
    Perhaps you could try to store it as a ’Custom data item’ or as a ’Resource’.

    Mary
  2. 0
    Nilo Souza ·
    I tried it (CDI) but not worked because the variable assumes the value of OD on each Activity and not the sum of all OD. Did you understand ? I need the sum of all OD and store this sum in a variable that i can use in a global change.

    Thanks !!
  3. 0
    Mary JoAnn ·
    Are you sure u don’t want to try this outside P3 ? Trying to Subtotal the grouping by activity codes in Excel could be one alternative.

    Also try looking at Resources if CDI dont serve your purpose.


  4. 0
    Raja Izat Raja Ibrahim ·
    dear Mr nilo
    u can go to > format >organize >and there is a form "Group By" , so u can see total, click on that box, there is option top or bottom, then organize ....u can see the result.
    but i dont understand your question, what to do with global change...? can u explain on that so i can help....

    cheers
  5. 0
    Sukumaran Subaramaniyan ·
    Hi,

    Use Hammock activity. The function is same like subtotal bar. It will give the sum of OD for each grouping. Then you can store it as CDI.

    Regards.
  6. 0
    Steven Oliver ·
    Beg to differ, but hammocks and group summaries show the elapsed duration i.e from the earliest early start date until the latest early finish date, not the sum of the durations.

    Try using the $tmp functionality in Global change, or use Excel.


    HTH


  7. 0
    Joy Fernandes ·
    Hi,
    Excel would be the best way of doing it.
    Steven could u tell me more about $temp functionality.

    Thanx.
  8. 0
    Steven Oliver ·
    Sorry, I remember now its &tmp. Look in the help
  9. 0
    Sukumaran Subaramaniyan ·
    Thought Nilo is asking for the subtotal/total figures as appearing on summary bars. Anyway, what is your feedback Nilo?

    Steven, I couldn’t find &tmp in P3 help. What is the full name of the function?

    Regards.
  10. 0
    Nilo Souza ·
    Thanks all !!!

    But i don´t want use Excel. I wanna do it into the primavera.
  11. 0
    Sukumaran Subaramaniyan ·
    Nilo,

    First
    Go to: Custom Data Items > Activity tab and create Sum Orig Dur (SODR) and type as N (Numeric).

    Second
    Go to: Global Change > Change tab > Then: SODR=EQ=OD and Run.

    You will get the duration for each individual activity and the total duration for each coding.

    HTH.
  12. 0
    Sukumaran Subaramaniyan ·
    Hi,

    Attach is the sample for your review.

    Free Image Hosting at www.ImageShack.us

    Regards.
  13. 0
    Joy Fernandes ·
    Hi Suku,
    Go to - Help - Global change- Temporary variables.
    It is explained better with 2 examples .


    HTH.
  14. 0
    Ayman Eleish ·
    hi
    creat a dummy resource for ex.(durn)
    by global change let it equal to od then organize by resource or deal it as u want

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?