Calculate Expected Percentage Complete for Project Tasks

[malaSa]

I was recently working with a consultant and provided a solution to calculate the 'Expected percentage complete" which is being requested by our PMs. We had this in a previous tool and I need to replicate in Workfront.

The recommendation is below, however I need guidance on how to go about doing this:

[Consultant block]: You can create a workaround to calculate and report on this by comparing the task's planned progress to its actual progress. This can be done through calculated fields in reports. Here's how you can approximate the **"Expected Percentage Complete"**:

1. Calculate Expected Percentage Complete:
1. This can be done by dividing the number of days that have passed in the task’s timeline by the total duration of the task.
2. Formula: `(Current Date - Planned Start Date) / (Planned Completion Date - Planned Start Date) * 100`
3. This will give you a percentage of how far along the task *should* be based on the planned timeline.
2. Compare Actual Progress:

1. You can then compare this expected percentage with the **Actual Percentage Complete** (available in Workfront as the `% Complete` field) to determine if the task is on track.

To implement this, in a report, you could create a calculated field using the formula above to track "Expected Percentage Complete". The report would then allow the Project Manager to compare the actual progress of tasks against their expected progress at any given time.

[Consultant block end]

[Mala]: I started off by creating a "custom calculated field" on a form and then added that field as a column in a custom view under the project Tasks, but no results display.

This is the formula I came up with for the 'expected percentage complete" within the calculated field = 

ROUND(PROD(DIV(DATEDIFF($$TODAY,{plannedStartDate}),DATEDIFF({plannedCompletionDate}, {plannedStartDate})),100),2)

I'm not sure if I need to do this as a calculated column and how would I write that syntax. I also need to display as a percentage similar to the "%Complete" field.

Any guidance you can provide would be greatly appreciated!

Mala