Calculating the Duration Between Actual Start Date of One Task and Actual Completion Date of Another

[dcshanno]

I've created a report filtering for two parent tasks within one project: Plan Campaign and Execute Campaign. I want the report to show the number of weekdays that transpired between the actual start date of the Plan Completion parent task and the actual completion date of the Execute Campaign task. Any tips?

Thank you in advance!

[Sven-iX · Accepted solution]

@dcshanno 

You can't.

When you do a task report you get those 2 rows, each a task that has no connection to the other task. Therefore you can't create a calculation. 

Instead, if you put these 2 task inside a parent "Campaign" you automatically get the calculation in the duration property of that (grand)parent task "Campaign."

[dcshanno]

Thank you!

[Doug_Den_Hoed__AtAppStore]

Hi @dcshanno,

Building on the sage advice from @Sven-iX, I invite you to consider this Going the Extra Milestone advanced technique to get what you need with minimal disruption to your existing Workplan structure(s).

If you like the latter, you can templatize it, going forward.

Going backwards...

If you want to take it even further, you could then also use our Sync Template solution to update existing Projects with those updated Template changes now, and thereafter, in a continuous improvement manner.

Regards,

Doug