Filter

Submitted by Dan Mårtensson on
Microsoft Project

Member for

15 years 9 months
Member for 15 years 9 months
Submitted by Dan Mårtensson on Fri, 2011-05-20 09:43
Permalink

Hello,

 

 

Please correct me if I am wrong with this formula in flag field.

 

 

For planed baseline activities

 

IIf([Status Date]>[Baseline Finish];IIf([Status Date]>=[Scheduled Duration]/480;ProjDateDiff([Scheduled Start];[Status Date])/480);0)

 

 

For actual finish in period

 

IIf([Status Date]>[Actual Finish];IIf([Status Date]>=[Scheduled Duration]/480;ProjDateDiff([Scheduled Start];[Status Date])/480);0)

 

 

Regards

 

 

Dan

Member for

16 years 7 months
Member for 16 years 7 months
Submitted by Gary Whitehead on Thu, 2011-05-19 13:05
Permalink

Hi Dan,

 

Create a custom flag (tools > customise > fields) using a couple of IIF functions, and filter on that.

The sytax won't be right on the below, but something like:

 

IIF((percentage complete = 100, IIF(finish <today-21, "Filter out", "Keep"), "Keep"))

 

Would mean any activity completed more than 3 weeks ago would be flagged "Filter Out"

 

Cheers,

 

G