Troubleshooting

A filter doesn't display the correct tasks

Making changes to your project can cause what appear to be incorrect filter results. If you make changes to your project after a filter is applied, elements that no longer meet the filter criteria don't disappear until you reapply the filter. You can reapply the current filter by pressing Ctrl+F3.

Table 25-1 describes the tests you can use within a filter and provides an example of each.

Table 25-1. Filters

Filter Test

How You Can Use It

Equals

The values must be equal. For example, to filter for mile

stones, test whether the Milestone field equals Yes.

Does Not Equal

The values are different. For example, to show tasks with

overtime, use the test Overtime Work field does not equal 0.

Is Greater Than

The Field Name value is greater than the entry in the Value(s)

cell. For example, to show tasks that are late, check whether

the Finish field is greater than the Baseline Finish field.

Is Greater Than Or Equal To The Field Name value is greater than or equal to the entry in

Is Greater Than Or Equal To The Field Name value is greater than or equal to the entry in the Value(s) cell. For example, to show tasks at least 50 percent complete, test whether the % Complete field is greater than or equal to 50 percent.

Is Less Than The Field Name value is less than the entry in the Value(s) cell.

For example, to show tasks that are ahead of schedule, check whether the Finish field is less than the Baseline Finish field.

Is Less Than Or Equal To The Field Name value is less than or equal to the entry in the

Value(s) cell. For example, to show tasks that are under budget, test whether the Cost Variance field is less than or equal to 0.

Table 25-1. Filters

Filter Test

Contains Exactly

How You Can Use It

Is Within The Field Name value is between or equal to the boundary val ues in the Value(s) cell. For example, to find the tasks within a range, test whether the ID is within the range specified in the Value(s) cell. To specify a range, type the starting value, type a comma, and then type the last value, such as 100,200.

Is Not Within The Field Name value is outside the boundary values in the

Value(s) cell. For example, to find the tasks that are not in progress, test whether the % Complete is not within 1%-99%.

Contains The Field Name value is text that contains the string in the

Value(s) cell. For example, to find the tasks to which a resource is assigned, test whether the Name field contains the resource name.

Does Not Contain The Field Name value is text that does not contain the string in the Value(s) cell. For example, to find resources not in a resource group, check whether the Resource Group does not contain the name.

The Field Name value is text that must exactly match the string in the Value(s) cell. For example, to find tasks to which only a particular resource is assigned, check whether the Resource Name field contains exactly the resource's name.

Project Management Made Easy

Project Management Made Easy

What you need to know about… Project Management Made Easy! Project management consists of more than just a large building project and can encompass small projects as well. No matter what the size of your project, you need to have some sort of project management. How you manage your project has everything to do with its outcome.

Get My Free Ebook


Post a comment