Filter trick

R
Rodel Marasigan 👤 Member for 19 years 7 months

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)

Forum Sponsor

Top Posters

Nick Johnson-Pond
3 posts
sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts