dmg234 said:
Hi John
I need to also filter out items that should have started/finished that have
not progressed to the current date.
For example Task 1 should be 80% complete today it is only 70% complete,
Task 2 is on target and is 90% complete today.
I would like the filter to filter out task 1 and not task 2.
Thanks, Regards
dmg234
dmg,
I don't have Project open at the moment so I'm going to give you a
pseudo-approach (i.e. not detailed and not tested).
First I'll assume by percent complete you are talking about the Percent
Complete field versus the Percent Work Complete field. They aren't
necessarily the same.
As far as I know there is no way to set up a filter directly using
Project's built in fields to do what you want. It is however relatively
simple to create a custom field with a formula to calculate the "should
be" percent complete as of the current date. That can then be compared
to the value entered into the Percent Complete field and the result will
be the basis for the filter.
I'd use a spare task text field for the formula. Start by calculating
the duration from the task start to the current date. This should be as
simple as subtracting the two dates. Calculate "should be" percent
complete by dividing the total task duration by the above value.
Finally, use an "iff" function to compare the percent complete values
and set the spare field to yes or no.
Create your filter using the value calculated in the spare field.
Hope this helps.
John
Project MVP
