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

Member for

20 years 1 month

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

Member for

20 years 8 months

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.

Member for

20 years 8 months

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.

Member for

23 years

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




Member for

20 years 8 months

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.

Member for

20 years 5 months

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

Member for

22 years 8 months

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.




Member for

20 years 3 months

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 !!