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.

Original Duration

6 replies [Last post]
Hafiz Khalid Hussain
User offline. Last seen 8 years 9 weeks ago. Offline
Joined: 13 Jun 2012
Posts: 5
Groups: None

Good evening everybody,

I want to filter only those activities having EVEN (Multiple of 2) original duration throughout the schedule. Can someone give me the trick for that kind of filter or grouping?

Replies

zahid shaikh
User offline. Last seen 5 years 7 weeks ago. Offline
Joined: 24 Aug 2016
Posts: 35

Just curious why are you looking to filter that? Any specific situation that is requiring you to filter activities with that duration?

Zoltan Palffy
User offline. Last seen 4 weeks 2 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

dody I will not answer this becasue you stepped on someone elses thread. If you have a question create a new post and ask it. You question has NOTHING to do with the original question.

dody sujasman
User offline. Last seen 5 years 49 weeks ago. Offline
Joined: 20 Mar 2015
Posts: 2
Groups: None
Dear Professionals,total original duration on WBS does not represent total duration in detail of its activity ..how to fix it? Thanks,Dody.S
Zoltan Palffy
User offline. Last seen 4 weeks 2 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

since you should not have any durations over 20 working days then 

filter all

where original duration is not equal to 1

where original duration is not equal to 3

where original duration is not equal to 5

where original duration is not equal to 7

where original duration is not equal to 9

where original duration is not equal to 11

where original duration is not equal to 13

where original duration is not equal to 15

where original duration is not equal to 17

where original duration is not equal to 19

Raymund de Laza
User offline. Last seen 31 weeks 5 days ago. Offline
Joined: 23 Nov 2009
Posts: 762
Create UDF for the result of Orig Dur/2 THEN filter using UDF that does not contain .5
Raymund de Laza
User offline. Last seen 31 weeks 5 days ago. Offline
Joined: 23 Nov 2009
Posts: 762
Create UDF for the result of Orig Dur/2 THEN filter using UDF that does not contain .5