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.

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

14 replies [Last post]
Mon, 2005-08-01 20:08
Nilo Souza
User offline. Last seen 9 years 41 weeks ago. Offline
Joined: 1 Aug 2005
Posts: 7
Groups: None
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.
Top

Replies

Sat, 2005-10-01 11:57
#1
ayman eleish
User offline. Last seen 15 years 46 weeks ago. Offline
Joined: 22 Sep 2005
Posts: 20
Groups: None
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
Top
Thu, 2005-08-04 03:00
#2
Sukumaran Subaram...
User offline. Last seen 9 years 8 weeks ago. Offline
Joined: 2 Mar 2005
Posts: 229
Groups: GPC Malaysia
Hi,

Attach is the sample for your review.

Free Image Hosting at www.ImageShack.us

Regards.
Top
Thu, 2005-08-04 02:36
#3
Sukumaran Subaram...
User offline. Last seen 9 years 8 weeks ago. Offline
Joined: 2 Mar 2005
Posts: 229
Groups: GPC Malaysia
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.
Top
Wed, 2005-08-03 20:29
#4
Nilo Souza
User offline. Last seen 9 years 41 weeks ago. Offline
Joined: 1 Aug 2005
Posts: 7
Groups: None
Thanks all !!!

But i don´t want use Excel. I wanna do it into the primavera.
Top
Wed, 2005-08-03 20:18
#5
Sukumaran Subaram...
User offline. Last seen 9 years 8 weeks ago. Offline
Joined: 2 Mar 2005
Posts: 229
Groups: GPC Malaysia
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.
Top
Thu, 2005-08-04 10:07
#6
Joy Fernandes
User offline. Last seen 8 years 48 weeks ago. Offline
Joined: 28 Dec 2004
Posts: 10
Groups: None
Hi Suku,
Go to - Help - Global change- Temporary variables.
It is explained better with 2 examples .


HTH.
Top
Wed, 2005-08-03 08:42
#7
Steven Oliver
User offline. Last seen 11 years 43 weeks ago. Offline
Joined: 8 Nov 2002
Posts: 313
Groups: None
Sorry, I remember now its &tmp. Look in the help
Top
Wed, 2005-08-03 08:39
#8
Joy Fernandes
User offline. Last seen 8 years 48 weeks ago. Offline
Joined: 28 Dec 2004
Posts: 10
Groups: None
Hi,
Excel would be the best way of doing it.
Steven could u tell me more about $temp functionality.

Thanx.
Top
Tue, 2005-08-02 03:13
#9
Steven Oliver
User offline. Last seen 11 years 43 weeks ago. Offline
Joined: 8 Nov 2002
Posts: 313
Groups: None
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


Top
Tue, 2005-08-02 03:03
#10
Sukumaran Subaram...
User offline. Last seen 9 years 8 weeks ago. Offline
Joined: 2 Mar 2005
Posts: 229
Groups: GPC Malaysia
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.
Top
Tue, 2005-08-02 02:56
#11
Raja Izat Raja Ib...
User offline. Last seen 13 years 16 weeks ago. Offline
Joined: 2 Jun 2005
Posts: 299
Groups: GPC Malaysia, Petro-Chem / Oil & Gas
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
Top
Mon, 2005-08-01 21:42
#12
Mary JoAnn
User offline. Last seen 17 years 29 weeks ago. Offline
Joined: 3 Mar 2003
Posts: 35
Groups: None
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.


Top
Mon, 2005-08-01 21:32
#13
Nilo Souza
User offline. Last seen 9 years 41 weeks ago. Offline
Joined: 1 Aug 2005
Posts: 7
Groups: None
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 !!
Top
Mon, 2005-08-01 21:03
#14
Mary JoAnn
User offline. Last seen 17 years 29 weeks ago. Offline
Joined: 3 Mar 2003
Posts: 35
Groups: None
Perhaps you could try to store it as a ’Custom data item’ or as a ’Resource’.

Mary
Top