Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Calculating slippage

Hi All,   I have a bunch of projects and there various milestone dates in a table that looks something like this:   Project ID Milestone A Milestone B Row created on 1 27/10/20 31/12/2...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Maggie,

 

This is not solved yet, sorry for the delay. I have posted again as a follow on.

v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

Hi Anonymous

I don't find any data about 2020/10/27.

Could you explain more for this?

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi v-juanli-msft, thanks for replying.

     

    The table I posted shows how I would have resolved this in Excel, unfortunately it appears as if the column titles are not lining up with their respective columns and this may be causing some confusion.

     

    They should read Project ID /-/ Milestone A /-/ Milestone B /-/ Row Created On /-/ Earliest Milestone A /-/ Most recent MilestoneA /-/ Days Slipped.

     

    As you can see from the data, 27/10/2020 is the first provided date for Milestone A (using the earliest corresponding date from the Row Created On Column). 16/10/2020 is the most recently provided date for Milestone A (row created on 9/1/2020 vs 1/1/2020). Thus the difference between these two is slippage of negative 11 days (IE the data has been brought forward).

     

    The solution provided in previous posts only looks for the earliest (lowest) and latest (highest) and wouldn't correctly identify that the slippage has reduced.

     

    Hope that helps to explain but please do reply if you need further clarification.