Quick Tip: Mixing AND and OR Options in Primavera P6 Filters

Quick Tip: Mixing AND and OR Options in Primavera P6 Filters

Building a filter where all the conditions are either ‘And’ or ‘Or’ between each row is pretty straightforward. However, if you want to mix them up a little its not so obvious how you should do that in Oracle Primavera P6 Professional. This quick tip will show you how.

Example: I want to find all the milestones in the project that have a date variance that is not equal to zero. In other words, I want to see any milestone that is now sitting on a date other than its baseline date.

Because there are two types of milestone in Primavera P6 Professional, Start and Finish milestones, it’s often necessary to use the ‘Or’ parameter to get them all. But if you need some ‘And’ conditions too, you need to do some extra thinking.

Here’s how the filter for the above scenario needs to look.

Variance Milestone Filter

Above: the first two conditions must both be met (the activity is not completed AND variance is not zero), and either of the second conditions can be met; in this case a start or a finish type milestone will meet the criteria.

To indent the Or condition rows under the And condition rows, we inserted a new row below the last ‘And’ condition and assigned the ‘(Any of the following)’ option to it. All subsequent rows will have an Or option in the first column until we insert another ‘(All of the Following)’ option.

Once you get tuned into this method, you can build very powerful and sophisticated filters. You do need to think these through before attempting to build them. I generally try to start with all the ‘And’ conditions first, and then put my ‘Or’ options below to avoid confusion and unnecessary complexity.

New Call-to-action

Author:
Neil, a Senior Consultant at Ten Six Consulting, has over 21 years experience in the Earned Value Management and Project Management field working across many industries including Aerospace and Defense, Biotech, Software Development and Government Agencies. He is an expert in in implementing Oracle Primavera P6, Deltek Cobra and wInisght and has developed and delivered training in all three products. Neil has worked with various EVM software products and Project Management tools since the early 1990’s. He has done extensive work on enterprise tool implementation, program setup, process development and training development for EVMS.