Filter delayed activities in P6.1

12 replies [Last post]
Roozbeh Taheri
User offline. Last seen 1 year 16 weeks ago. Offline
Joined: 19 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

ABDUL RAZEED RAJA
User offline. Last seen 9 weeks 4 days 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 3 days 22 hours ago. Offline
Joined: 13 Jul 2009
Posts: 1588

or where BL Finsh variance is greater than 0

Khuong Do
User offline. Last seen 3 weeks 2 days ago. Offline
Joined: 21 Feb 2010
Posts: 99
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 1 year 21 weeks ago. Offline
Joined: 7 Aug 2006
Posts: 66

hi

Add filter

Activity % complete - Not Equal to - 100

Anderson Charlie
User offline. Last seen 13 weeks 6 days 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 1 year 21 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 3 days 22 hours ago. Offline
Joined: 13 Jul 2009
Posts: 1588

filter where Variance - BL Duration  is greater than 0

Anderson Charlie
User offline. Last seen 13 weeks 6 days 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 1 year 21 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 14 weeks 5 days 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 9 weeks 2 days 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 34 weeks 4 days ago. Offline
Joined: 25 Oct 2006
Posts: 1516
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.