Post

1 follower Follow
0
Avatar

% complete as of a certain date

in the project list, % complete is always as of "now." Is it possible to calculate or retrieve % complete as of a certain date? Show me % complete for all projects as of April 30, for instance. Thanks.

Christopher Knaus Answered

Please sign in to leave a comment.

4 comments

0
Avatar

What I would recommend is using the Audit Tail app and modifying it to add % completion as one of the fields that is tracking.  That will let you see a history of every time the % completion changes, by who, and on what date.

Josh Santos 0 votes
Comment actions Permalink
0
Avatar

That is close as it would give me a running total, but would be difficult to get a report of "% complete of all projects as of X date" Can reports be triggered to run on a certain date? Maybe something like that?

Christopher Knaus 0 votes
Comment actions Permalink
0
Avatar

Also, Audit Trail only records manual changes to % complete. I need to know the % complete on a certain date whether it is manual or system determined.

Christopher Knaus 0 votes
Comment actions Permalink
0
Avatar

I don't think this will be doable at the moment without substantial customization. You would need a custom field for each date you would want to capture, and then a scheduled workflow rule that would update that field on the specific day.

Josh Santos 0 votes
Comment actions Permalink