Late/outstanding works report

[Elip]

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

 

[jblack34]

You might try this. Insert a text column. Name that column: Theoretical % Complete. Then copy in this formula:

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

http://www.pmconnection.com