Hello again,
I am stuck when it comes to creating two filters.
I'm looking to filter out complete activities until a specified date.
The start date should always be the same but the end date / reportdate is floating.
How can I get into such a filter?
The second filter is the same but based on the baseline.
Anyone?
BR
Dan
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
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