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.
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.