Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Filter

2 replies [Last post]
Thu, 2011-05-19 09:30
Dan Mårtensson
User offline. Last seen 11 years 20 weeks ago. Offline
Joined: 4 Feb 2010
Posts: 59
Groups: Civil Engineering

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

Top

Replies

Fri, 2011-05-20 08:43
#1
Dan Mårtensson
User offline. Last seen 11 years 20 weeks ago. Offline
Joined: 4 Feb 2010
Posts: 59
Groups: Civil Engineering

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

Top
Thu, 2011-05-19 12:05
#2
Gary Whitehead
User offline. Last seen 5 years 10 weeks ago. Offline
Joined: 24 Mar 2009
Posts: 1215
Groups: Building Information Modelling, Content Moderators, Petro-Chem / Oil & Gas, The GrapeVine

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

Top