Skip to content
ProjectControls.com
Microsoft Project

Filter

In the Open Standard
Dan MårtenssonMember for 16 years 8 months
Created
2
2
0

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

Save Follow Follow forum Report
Reply New topic

2 replies

Oldest first
  1. 0
    Gary Whitehead ·
    #1

    Hi Dan,   Create a custom

    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

    Report
  2. 0
    Dan Mårtensson ·
    #2

    Hello,  Please correct me if

    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

    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?