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.

Current period / this period, Progressed Activities, P6

17 replies [Last post]
abbas india
User offline. Last seen 9 years 40 weeks ago. Offline
Joined: 12 Jul 2009
Posts: 35
Dear All,

How to get / filter only the "this period" progressed activities in P6.

For example If I need to filter out the activities progressed during the current week/month etc..

Best regards,
Abbas

Replies

Nilesh Jain
User offline. Last seen 24 weeks 3 days ago. Offline
Joined: 22 Jan 2020
Posts: 13
Groups: None

Hi,

I'm trying to find the solution for the same question and after some research, the following are the steps that will help you to show % progressed for this period: (Make sure to copy the original schedule)

1. Step1: Create UDF  say '1. Previous Month % Complete'

2. Step 2: Create another UDH say ' 2. Progressed % for this period'

3. Step 3: Global Change->New->Call it Previous month % Complete

Then               Parameter                        Is              Parameter/Value             Operator               Parameter/Value

               1. Previous Month % Complete     =           Duration% Complete

Apply Changes->Commit Changes

4. Step 4: Store Period Performance

5. Step 3: Global Change->New-> Call it 'Progressed % for this period'

Then               Parameter                    Is              Parameter/Value       Operator               Parameter/Value

       2. Progressed % for this month     =       Duration % Complete             -              1. Previous Month % Complete 

6. Update the schedule 

7. Run the global change created in step 5.

Done!!

 

 

 

 

Zoltan Palffy
User offline. Last seen 21 hours 9 min ago. Offline
Joined: 13 Jul 2009
Posts: 2792
Groups: None

if you use stroe period performance you can use \

where cost this period is not equal to 0

if you are updatng it monhly

ANY

where

actaul start is with in the range of   DD-1M      DD        

or

actual finish is within the range of    DD-1m       DD

 

th eonly thing missing then would be activities that were in progress and that that have had incremental progressed  during this reporting period.

To get these you would have to  set the previous uddate as the baseline then create a udf and then run a global change to calculate the difference between the duration of physcial % complete q

Mohammed Ateeq Ur...
User offline. Last seen 17 weeks 2 days ago. Offline
Joined: 28 Oct 2017
Posts: 3
Groups: None

How to make filter for calculating positive gained progress means which is not supposed to start but started the activity

Rav B
User offline. Last seen 29 weeks 6 days ago. Offline
Joined: 20 May 2007
Posts: 1027
It depends what and how u want?

What u r always interested is measurement of progress between two reporting periods. This can be every week or every month or every fortnight and its minus from the data date of course....

I have tried to do it in P6, but it seems it is somewhat difficult do get this report directly from P6.

Cheers,

Ravi
Duy Huynh
User offline. Last seen 10 years 32 weeks ago. Offline
Joined: 24 Apr 2008
Posts: 22
Groups: None
HI Abbas,

I am not sure how you define your "current period"?
For example, based on Data Date, which one would you like to filter?

- One week/month right before Data Date, start from Data Date minus one week/month to Data Date.
- Or One week/month right after Data Date, start from Data Date plus one week/month forward.
- Or, a period somewhere in the past of Data Date?
abbas india
User offline. Last seen 9 years 40 weeks ago. Offline
Joined: 12 Jul 2009
Posts: 35
Dear Arnold,

I tried the filter but it lists some of the current period activities but it missed some progressed activities.

I think we have to do this using "Store Period Performance" as Mr. Ravi suggested. The thing is that it was working with P3 and how it can be done through P6.

Please let us know if somebody knows about it.


Best regards,
Abbas.
Arnold Puy
User offline. Last seen 5 years 38 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Hi Abbas,

In addition to Rav info. Try the following steps using P6.2

1. Create a new BL1.
2. The newly created BL1 must came from your last week update. Then assign the BL1 to your current project. This must be assigned into your Primary Baseline.
3. When done, create a new filter (Activity Progress This Week) with the following parameters:

- (All of the following)
Where: BL1 Actual Start "equals" Blank
And Physical % Complete "is greater than" 0%

Note:
1. Blank means no value at all. Leave the value blank.
2. Physical % Complete, if you are using physical otherwise, Performance, Duration..etc...

Just try these steps and let us know.

Regards,

Arnold


Rav B
User offline. Last seen 29 weeks 6 days ago. Offline
Joined: 20 May 2007
Posts: 1027
OK,

I will give a try this evening or by tomorrow in P6 and will let u know. Meanwhile, if u got anything, plz do fwd to us.

Cheers,

Ravi
abbas india
User offline. Last seen 9 years 40 weeks ago. Offline
Joined: 12 Jul 2009
Posts: 35
Hi Raviraj,

Thanks,

This is what I am looking for.

But I am looking how this can be done through P6.

Thanks,
Abbas.
Rav B
User offline. Last seen 29 weeks 6 days ago. Offline
Joined: 20 May 2007
Posts: 1027
U need to use Store Period Performance for this.

I have not tried this in P6, but in P3, it works superb.

Step I: After copying the program, Click on the Store Period Performance

Step II: Define CDI called PLQT (Planned Qty this period)

Step III: Then run a Global Change PLQT = BQWS

Step IV: Update the program

Step V: Run a Global Change T1 = BQWS - PLQT

Step VI: Go to Tabular reports and then make ur custom report using following columns:
BQ, BQWS, T1, QTP

T1 is Planned Qty. This period; while QTP is Actual this Period.

If u want, then u can add Variance Column too.

I am not sure of weather this works in P6 or not (especially BQWS), but works very well for me in P3. I will try sometime today in P6 too and will inform u later.

Cheers,

Ravi
abbas india
User offline. Last seen 9 years 40 weeks ago. Offline
Joined: 12 Jul 2009
Posts: 35
Hi Ruel,

Thanks for your advise.

Actually I need to get the this period gained progress that is Weekly or Monthly gained progress,

NOT the cumulative figure.

Can anybody give suggestion to my issue.

Thanks,
Abbas.
Ruel Camaquin
User offline. Last seen 6 weeks 1 day ago. Offline
Joined: 16 Nov 2008
Posts: 100
Abbas,

Maybe this could help,

1. Add 1 column and id it as percentage complete
2. Make a run date (current date is recommended)

From there you will see this period % complete of your project. If this is not what you want to get, sorry for that.

Cheers!

Ruel
abbas india
User offline. Last seen 9 years 40 weeks ago. Offline
Joined: 12 Jul 2009
Posts: 35
Dear All,

Can you help me by providing a reply to my query.


Thanks,
Abbas.
ROHIT RANGNEKAR
User offline. Last seen 11 years 12 weeks ago. Offline
Joined: 28 May 2009
Posts: 47
Groups: None
Dear Abbas,

There are not much people from india in this forum.

Can we share our thoughts ?

Regards,
abbas india
User offline. Last seen 9 years 40 weeks ago. Offline
Joined: 12 Jul 2009
Posts: 35
Hi,

Sorry please delete it.

thanks,
Abbas
David Wallace
User offline. Last seen 2 years 47 weeks ago. Offline
Joined: 10 Jun 2005
Posts: 100
Groups: None
Hi Abbas,

I’ve noticed you’ve posted this twice, I’m assuming in error, do you mind if I delete the other posting?

Thanks,

David.
Hemanth Kumar
User offline. Last seen 1 year 11 weeks ago. Offline
Joined: 1 Nov 2002
Posts: 260
Groups: None
There are several indians
But not working in India