Variance between project default baseline planned completion and the actual project planned completion? | Community
Skip to main content
A
AllisonSi
Level 2
July 20, 2021
Question

Variance between project default baseline planned completion and the actual project planned completion?

  • July 20, 2021
  • 1 reply
  • 762 views

Is there a way to do this? This is the only way I can think of to track the difference between our original planned timeline and the timeline as the project actually progresses.

I tried putting a custom field on a project custom form for manual entry of the original date and then trying a calculated field with date diff between that date and the project planned completion, but it wouldn't work.

Any ideas are helpful! Thanks,

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

R
Community Advisor
Richard_Le_Community Advisor
Community Advisor
July 20, 2021

Hi Allison,

You will be able to achieve this with a baseline report. Using the following text mode in one of your columns will return the date difference in weekdays between the Project planned completion date and the Baseline planned completion.

displayname=Planned Comp Variance

textmode=true

valueexpression=CONCAT(WEEKDAYDIFF({plannedCompletionDate},{project}.{plannedCompletionDate})," Days")

valueformat=HTML

You will probably also want to apply a filter to your baseline report for Baseline>>Is Default = True, otherwise the report will return all baselines associated with each project and not just the default one.

Hope that helps!

Best Regards,

Rich.

    A
    AllisonSiAuthor
    Level 2
    July 23, 2021

    This is perfect! Thank you so much.

    Terms & ConditionsAccessibility statement

    Loading footer...