How do can I calculate # days BEHIND ?

[LJI]

I'd like to be able to determine how many days behind a given project is,
relative to a given day when the staus is being checked in the Project Center.

I can get this visually from viewing the SUMMARY PROGRESS bar from a racking
Gantt, and subtracting 'today's date' from the Summary Progress date.

Is there a way I can automate this, by creating a custom field which I can
then insert in the Project Center Views?

This isn't the same as using a Variance Field, nor do I know how to get
today's date.

Thx

 

[John Sitka]

use a deadline on the final task, write a formula in a custom task number field that
works out a count in days

The inline IIF is utilized because if a task dosen't have a deadline it will generate an error

Date() is todays date


IIf(Deadline=ProjDateValue("NA"),0,Cint(DateDiff("d",Date(),Deadline)))


IIf(Deadline=ProjDateValue("NA"),0,Cint(DateDiff("d",Finish,Deadline)))

 

[Gary L. Chefetz [MVP]]

LJI:

If you save a baseline, then you simply need to look at a finish variance
field to determine this information as it's automatically calculated by
Project. What you can't do is dial back to a date before today, as the
stateful data is not preserved. You can, however, use the tracking tools to
save additional baselines and/or interim plans to refer back to.

 

[LJI]

John,
The below details worked great.

I've got the calulation result, yet I'm still trying to figure out why it
isn't an
'available field' inside the Manage Views editor.

I assigned the formula to an Enterprise Global Custom Field, type= number, but
the renamed field doesn't show up in the list, and hence I can't add it to
the display fields. I'll continue to work this aspect, but wanted to at
least let you know I'm much closer with your input.

Appreacite the help.
LJI

 

[John Sitka]

I think you need to get to the correct type of view, hopefully that will gel with the view you are using but in a lot of
cases various views can be made to show the same information to a degree.

four general steps.

the enterprise Global customization may need to be defined in a as a published field if the view is a task view
each project needs to be recalculated (F9 key) and saved,
each project needs to have that customized value as a published field
the view has to be of the correct type and draw from the correct information table

in this case Project and Task,

So from Project Center click a project to view,
once looking at that Project in "View A Project"
then observe your modified task evaluation view of the Project and it should be there.

always make copies of the view that you think you want to modifiy rather than modifying the base views.
then you can keep trying till it works and delete the ones you mess up.

 

[LJI]

Gary,
I'm not sure the variance is the same thing?

A simple example:
A summary task : BL Finish = 8/30/06 Start 7/10/06 Finish 9/7/06
Tracking Gantt -> Summary Progress date = 8/3/06 (35% cmplt)

If I check the status of this task on 8/15/05 - the progress is 12 days
behind schedule! While the Finish Varaince is only 5days.

The 12days is the value I'm trying to capture.

Is there a way to obtain the SUMMARY PROGRESS DATE in an equation?

 

[anajovanova]

Hi,

I am also interested about this question, and I realy need the answer
for the Summary progress date (Tracking Gantt -> Summary Progress date
= 8/3/06 (35% cmplt))

How can I calculate that date of progress.

IT IS VERY IMPORTANT TO ME

Thanks.


LJI напиша:

 

[Gary L. Chefetz [MVP]]

LJI:

In my post I assume that tracking is not 12 days old, so you're correct, the
formula is a better approach.