Mismatch between custom duration formula and project settings duration column
Why do I often get a 1 in a custom duration calculation of same-day work vs. project settings calculation, which shows 0?
During some import troubleshooting, I created a "baseline duration" and "revised duration" column to compare my own formula for calculating duration to the durations provided by project settings.
My formula for calculating "Baseline Duration" is here:
=NETWORKDAY([Baseline Start Date]@row, [Baseline End Date]@row)
"Revised Duration" Project settings look at Revised Start Date and Revised End Date.
So, for the most part, these numbers will match. Here are some circumstances where they do not.
Baseline Start Date 10/27/20
Revised Start Date 10/27/20
Baseline End Date 10/27/20
Revised End Date 10/27/20
Baseline Duration 1
Revised Duration 0
Best Answer
-
Because the function you are using considers that as 1 day whereas the project settings see it as a milestone which has a zero day duration.
Answers
-
Because the function you are using considers that as 1 day whereas the project settings see it as a milestone which has a zero day duration.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!