I have built a task report that gives me the status of a task task contains build in the name on a project, using the approval path start date
vs the project planned completion date
See attached screen grab
So, on this I can clearly see that based on the build task Approval start date vs Project planned completion date
it was early by 1.27 days so in essence on time (column OTD based on build handover)
And i can see the project status classes as late
Is the below possible
I want to in essence say
if the project has a build task, return the (OTD Based on Build Handover) Value for the build task otherwise return the project progress status
and have this at project level
So, the example below would actually say this project was on time and not late as stated (as we want the build handover to determine this)
Then i want to be able to report on it
Any help appreciated
Many thanks Dan