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

N
Nilo Souza 👤 Member for 20 years 10 months
A
ayman eleish 👤 Member for 20 years 8 months

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

S
Sukumaran Subaramaniyan 👤 Member for 21 years 3 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.

N
Nilo Souza 👤 Member for 20 years 10 months

Thanks all !!!



But i don´t want use Excel. I wanna do it into the primavera.

S
Sukumaran Subaramaniyan 👤 Member for 21 years 3 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.

J
Joy Fernandes 👤 Member for 21 years 5 months

Hi Suku,

Go to - Help - Global change- Temporary variables.

It is explained better with 2 examples .





HTH.

J
Joy Fernandes 👤 Member for 21 years 5 months

Hi,

Excel would be the best way of doing it.

Steven could u tell me more about $temp functionality.



Thanx.

S
Steven Oliver 👤 Member for 23 years 7 months

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




S
Sukumaran Subaramaniyan 👤 Member for 21 years 3 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.

R
Raja Izat Raja Ibrahim 👤 Member for 21 years

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

M
Mary JoAnn 👤 Member for 23 years 3 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.




N
Nilo Souza 👤 Member for 20 years 10 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 !!

M
Mary JoAnn 👤 Member for 23 years 3 months

Perhaps you could try to store it as a ’Custom data item’ or as a ’Resource’.



Mary

Forum Sponsor

Top Posters

Dimitrios Theocharidis
3 posts
MichaelFuelsC
0 posts
anwar zeb
1 posts
olva seselima
1 posts
Muhammd Muneer
0 posts
sairam
0 posts
MARAT BILYALOV
0 posts
RichTea66
0 posts
Muneer Muhammad
1 posts
Manny Onifade
5 posts