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.

Filter delayed activities in P6.1

13 replies [Last post]
Roozbeh Taheri
User offline. Last seen 7 years 35 weeks ago. Offline
Joined: 20 May 2003
Posts: 38
Groups: None
How I can filter delayed activities in P6.1? I want to have a list of activities with schedule % complete grater than duration % complete.

Replies

Philip James
User offline. Last seen 38 weeks 15 hours ago. Offline
Joined: 20 Mar 2016
Posts: 20
Groups: None

 

Bit of an old thread.

However. Can you have filter what was planned to start and didn't and what planned to finish and didn't - in the period on the same filter?

I used the examples below on two separate filters, but of course. If filters activiities that match 'both' -

 

How do I write the filter to have 'planned start' or 'planned finish'?

 

Where " BL Start" is "is lessthan" Value "DD"

and "Actual start is "equals" "blank" (Dont ype anything leave just blank

You will get the "activities planned to start but not started" same way you filter " Activiites planned to finish but not finished"

 

OR

 

To filter " Activiites planned to finish but not finished

Where " BL Project Finish " is "is lessthan" Value "DD"

and "Actual Finsh is "equals" "blank" (Dont type anything leave just blank)

 

Regards

Philip

ABDUL RAZEED RAJA
User offline. Last seen 6 years 27 weeks ago. Offline
Joined: 12 Oct 2017
Posts: 4
Groups: None

GUYS BEST WAY TO DO IS FILTER SCHEDULE VAIRANCE INDEX-LABOR UNIT LESS THAN ZERO. ITS AVAILABLE INSIDE COLUMN EARNED VALUE .

BY FILTERING SUPPOSE TO START BUT NOT STARTED, SUPPOSE TO FINISH BUT NOT FINISH WILL NOT GIVE STARTED BUT THE PROGRESS IS NOT UPTO THE MARK AND WILL FINISH LATE. ALSO VARIANCE OF BL DURATION WILL ONLY GIVE THOSE ACTIVITIES WHICH TOOK LONGER TO COMPLETE THEN THE PLANNED

Zoltan Palffy
User offline. Last seen 4 weeks 19 hours ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

or where BL Finsh variance is greater than 0

Khuong Do
User offline. Last seen 2 years 2 weeks ago. Offline
Joined: 22 Feb 2010
Posts: 118
Groups: None

Hi,

I write an article regarding How to quickly identify Behind Schedule and Over Budget activity by Indicator UDF in Primavera P6.

If you're interested, kindly read it here https://doduykhuong.com/2017/03/14/how-to-quickly-identify-behind-schedule-and-over-budget-activity-by-indicator-udf-in-primavera-p6/

Santhosh kumar Na...
User offline. Last seen 6 years 18 weeks ago. Offline
Joined: 7 Aug 2006
Posts: 66

hi

Add filter

Activity % complete - Not Equal to - 100

Anderson Charlie
User offline. Last seen 6 years 32 weeks ago. Offline
Joined: 25 Apr 2016
Posts: 13

Thanks, but it just show the activities that has 0% actual. What about the actvitities that has started with > 0% but not completed yet? 

Santhosh kumar Na...
User offline. Last seen 6 years 18 weeks ago. Offline
Joined: 7 Aug 2006
Posts: 66

Hi Anderson

I have explained in my comment is self

You can filter the delayed activities

Where " BL Project Start" is "is lessthan" Value "DD"

and "Actual start is "equals" "blank" (Dont ype anything leave just blank

You will get the "activities planned to start but not started" same way you filter " Activiites planned to finish but not finished"

 

To filter " Activiites planned to finish but not finished

Where " BL Project Finish " is "is lessthan" Value "DD"

and "Actual Finsh is "equals" "blank" (Dont type anything leave just blank)

 

Santhosh

Zoltan Palffy
User offline. Last seen 4 weeks 19 hours ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

filter where Variance - BL Duration  is greater than 0

Anderson Charlie
User offline. Last seen 6 years 32 weeks ago. Offline
Joined: 25 Apr 2016
Posts: 13

Hi Santhosh,

 

Thanks for the comment you left, help me alot. Just want to inquire regarding the activities that scheduled to finish, but not yet finish does not come out. Could you please help me?

 

Thanks man.

Santhosh kumar Na...
User offline. Last seen 6 years 18 weeks ago. Offline
Joined: 7 Aug 2006
Posts: 66

hi folks

You can filter the delayed activities

Where " BL Start" is "is lessthan" Value "DD"

and "Actual start is "equals" "blank" (Dont ype anything leave just blank

You will get the "activities planned to start but not started" same way you filter " Activiites planned to finish but not finished"

 

Santhosh

Gary Whitehead
User offline. Last seen 4 years 46 weeks ago. Offline

Note that this filter will show activities with an extended duration.

It won't show activities that have started late but retained the same duration.

Instead of variance to duration, I prefer to use variance to finish date.

 

Also I prefer to set my baseline not to current project, but to a baseline project when checking schedule variance -either the contract baseline, or a copy of the project from previous update period.

Mohd Firdaus Firdaus
User offline. Last seen 2 years 40 weeks ago. Offline
Joined: 30 Jan 2012
Posts: 3
Groups: None

Rodel,

Thanks a lot for your kind info...really appreciate it =)

Rodel Marasigan
User offline. Last seen 1 day 3 hours ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Roozbeh,
Use Variance BL Project Duration to filter all delayed activities. (Column-> Durations-> Variance-BL Project Duration) Any below zero values are delay. You must assign Current Project as Project Baseline.