PWA not showing overall status in Project Center

J

jim

This is the problem i am seeing with PWA Server 2003 - i have a status
indication based on the number of days something is behind or ahead in a
project. One is calculated off of baseline, the other is measured off of
deadlines (which is much more important to our business operation). here are
the two formulas i am using at the "enterprise text" level of custom fields:

IIf([% Complete]=100,"Complete",IIf([Baseline Finish]=4294967295,"No
baseline",[Finish Variance]/480))

ProjDateDiff([Deadline],[Finish])/480

The top one works fine the entire way through the project and rolls up all
the way to the Project title level and is visible in the PWA Project Center
view. The second one, the one i am really interested in, only works on the
task where a deadline is assigned and does not roll it's indicators
(stoplights) into the summary tasks. The second one is visible in the PWA
Project view (it does not roll up as i said) and it does not work at all in
the PWA Project Center view.

I am guessing that there is some switch/option somewhere i am missing - and
can not find. Or, the formula style i am useing is not appropriate for the
information i am trying to gather.

any help would be appreciated.
 
J

Jonathan Sofer

Deadline does not rollup to the project level. It is always NA at the
project level I believe. What would you expect the deadline to be at the
project level if deadlines at the task levels are all different dates?

Jonathan
 
J

jim

i would expect, just like with the baseline variation formula, that the
largest date difference would be shown at the summary task or project task
level.

Jonathan Sofer said:
Deadline does not rollup to the project level. It is always NA at the
project level I believe. What would you expect the deadline to be at the
project level if deadlines at the task levels are all different dates?

Jonathan

jim said:
This is the problem i am seeing with PWA Server 2003 - i have a status
indication based on the number of days something is behind or ahead in a
project. One is calculated off of baseline, the other is measured off of
deadlines (which is much more important to our business operation). here
are
the two formulas i am using at the "enterprise text" level of custom
fields:

IIf([% Complete]=100,"Complete",IIf([Baseline Finish]=4294967295,"No
baseline",[Finish Variance]/480))

ProjDateDiff([Deadline],[Finish])/480

The top one works fine the entire way through the project and rolls up all
the way to the Project title level and is visible in the PWA Project
Center
view. The second one, the one i am really interested in, only works on
the
task where a deadline is assigned and does not roll it's indicators
(stoplights) into the summary tasks. The second one is visible in the PWA
Project view (it does not roll up as i said) and it does not work at all
in
the PWA Project Center view.

I am guessing that there is some switch/option somewhere i am missing -
and
can not find. Or, the formula style i am useing is not appropriate for
the
information i am trying to gather.

any help would be appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top