% Complete Forecast to Future Date

Is there a way to project a POC (Percentage of Completion) to a certain Date?

The assumption is that the baseline schedule has been vetted, and agreed upon.

What I would want to do is forecast for example what the POC would be to the end of the Month, or to the end of the Next Month - I'm at May 30th right now, so I can recognize what is is now (say 8%) but I'm being asked to forecast where the project will be on June 30th and July 31st.

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

You would use something like this...

(DATE(date_you_want_to_project_to) - [Start Date]@row) / ([End Date]@row - [Start Date]@row)

jwnek

Paul,

How would you modify this formula to show a "weighted" percent complete, by month (or a specific date).

So I would like to show a projection, of what the expected weighted percent complete will be.

I would like to show this for the future 24 months of the project.

Thanks in advance.

jwnek

📈

LCrane

Hi @jwnek Did you receive a response to your last message? I am looking for this as well. Thank you@

jwnek

Hello, I did not receive a response to my question yet, sorry. Still have not been able to create a formula that works, to forecast a weighted percent complete.

If you have any luck, please let me know.

Sandy Drew

Hello, I used something similar to this formula for a client before. They utilized an Expected % Complete column to compare against their actual % complete. (C@row is a simple count(children()) formula helper column)

=IFERROR(IF(C@row > 0, AVGW(CHILDREN([Expected Completion %]@row), CHILDREN(Duration@row)), IF(TODAY() < Start@row, 0, IF(TODAY() >= Finish@row, 1, (NETWORKDAYS(Start@row, TODAY()) / Duration@row)))), "ERROR")

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.