Calculated Custom Field Help - How to show variance between Planned Completion and Actual Complete Date | Community
Skip to main content
E
EricRo1
Level 2
October 8, 2019
Question

Calculated Custom Field Help - How to show variance between Planned Completion and Actual Complete Date

  • October 8, 2019
  • 1 reply
  • 542 views
Hi All, Look for any suggestions. I would like to create a calculated custom field showing the variance (days late or days ahead) of project planned completion date vs actual completion date. I have tried created a custom field using this formula: SUB(Actual Completion Date,Planned Completion Date) and adding the custom form to the projects in question. I added the column to the report view but I cannot get the calculation to formulate. Any ideas on what I am doing wrong or how to get this report to work? Eric Roybal Director, Project Management One & All
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

E
EricRo1Author
Level 2
October 8, 2019
found it: For the difference between Planned Date and Actual Completion Date, the formula would look like this. WEEKDAYDIFF( Planned Completion Date,Actual Completion Date ) Eric Roybal Director, Project Management One & All
Terms & ConditionsAccessibility statement

Loading footer...