Calculate delivery risk from expected progress

What is the challenge?

• I need to compare expected and actual progress. I cannot automatically mark records at risk by calculating expected progress and comparing it with actual progress

What is the impact?

• I cannot identify delayed work automatically.

• I spend time reviewing progress manually.

• Risks may remain unnoticed until delivery is threatened.

Describe your idea.

• Expected progress would be calculated by using the start and end date to calculate the total duration of the work, and then using today's date to calculate the expected progress percentage.

• This can then be compared with the actual progress percentage.

• I want delayed records marked at risk automatically.