Filter delayed activities in P6.1

Member for

9 years 7 months

 

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

Member for

8 years

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

Member for

16 years 3 months

or where BL Finsh variance is greater than 0

Member for

19 years 2 months

hi

Add filter

Activity % complete - Not Equal to - 100

Member for

9 years 6 months

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

Member for

19 years 2 months

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

Member for

16 years 3 months

filter where Variance - BL Duration  is greater than 0

Member for

9 years 6 months

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.

Member for

19 years 2 months

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

Member for

16 years 7 months

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.

Member for

13 years 9 months

Rodel,

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

Member for

19 years

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.