Late/outstanding works report
Late/outstanding works report
(OP)
Hi all
I have to make a list of late/outstanding activities
My Msp program has not any baseline saved it is updated by people at the workshop thay only update the complete % so there are many actuals in future or remaining work in the past I've been asked to create a filter to report late activities without changing the program.
Therefore I made the following filter:
start is less than or equal to "status date"?
and Actual start equals NA
or
finish is less than or equal to "Status date"?
and Actual finish equals NA
or
resume is less than "status date"?
and complete% does not equal 100%
I have 2 questions
1- Does it filter all late/outstanding activities?
2- With this filter the user is being asked 3 time to enter status date is there a way for only asking once?
Thank you
I have to make a list of late/outstanding activities
My Msp program has not any baseline saved it is updated by people at the workshop thay only update the complete % so there are many actuals in future or remaining work in the past I've been asked to create a filter to report late activities without changing the program.
Therefore I made the following filter:
start is less than or equal to "status date"?
and Actual start equals NA
or
finish is less than or equal to "Status date"?
and Actual finish equals NA
or
resume is less than "status date"?
and complete% does not equal 100%
I have 2 questions
1- Does it filter all late/outstanding activities?
2- With this filter the user is being asked 3 time to enter status date is there a way for only asking once?
Thank you
RE: Late/outstanding works report
ProjDateDiff([Start date];Date();[Project Calendar]))*100)/([Duration]
Now you can compare % Complete and Theoretical % Complete to see the variance.
Hope this helps!!
J Black
www.pmconnection.com