Website Upgrade Incoming - we're working on a new look (and speed!) standby while we deliver the project

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 trick

2 replies [Last post]
Izam Zakaria
User offline. Last seen 8 years 28 weeks ago. Offline
Joined: 28 May 2006
Posts: 221
Sorry guys, I’m out of my mind ...

Is it anyone has any idea if I want to come out the filter such like below….

If OD = RD and
physical % greater than 0


TQ

Replies

Izam Zakaria
User offline. Last seen 8 years 28 weeks ago. Offline
Joined: 28 May 2006
Posts: 221
Thanks buddy, really appreciate that nice solution
Rodel Marasigan
User offline. Last seen 23 weeks 19 hours ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Hi Izam,

Unfortunately that is not possible as the filter criteria required a value and not a field.
Work around: Create a number users define field (i.e. var_dur) then run a global change (where percent complete type equals physical then var_dur = Original Duration – Remaining Duration)
Now you can use the filter (where var_dur equals 0 And Physical % Complete is greater than 0)