Hi All,
I've created a Task report, and I'm trying to calculate actual durations for tasks in this year's projects (in order to update our templates for next year). It's been determined that the Actual Duration field is of limited value because in many cases, users marked tasks complete without first clicking on Start Task or changing the status from 'New' to 'In Progress' (causing the Actual Duration to have a value of zero).
I've thought of calculating the weekday difference between the task Handoff Date and the Actual Completion Date. I think this will work if the task actually has a handoff/predecessor. I'm going to want to create a different calculation (still to be determined) if the task has no predecessor.
Could someone please help me create an appropriate IF conditional to test for the presence of a predecessor? I've looked at both the text mode of the Task>>Predecessors field and the API, but I'm not having any luck correctly identifying tasks that have no predecessors.
Thanks,
Kristen