Project Server 2007 - Formula Question

[CQ]

I have a formula which works great, but doesn't do what I want for the
Project Summary Task. I have created a new field and called it "NegSlack".
The formula finds any task that has negative slack and gives me the result.
This is fine. However, what I want to see is if ANY single task has negative
slack, the Project Summary task line to show me the negative slack result.
Instead, it calculates as well. It appears that there is no "rollup" option
in Project Server 2007. If I make this custom field a "Project" entity then
it doesn't even give me the option to "calculate the summary row" and if I
use my formula on a "task" entity then it doesn't give me the rollup option -
it is either "none" or "use formula". The issue is that I can have a task
with negative slack but the overall project is not negative.
Here is the formula I am using: IIf(([Total Slack]<0),"NegSlack","Good")
What I need is some sort of modificaiton to this that says if "any task has
total slack <0 then give me "NegSlack".
Any thoughts?

 

[Dale Howard [MVP]]

CQ --

Why don't you create a custom filter to display negative slack according to
your requirements? And then why don't you apply the task Schedule table and
select the custom filter? How would that not meet your criteria?

 

[CQ]

Thank you for the suggestions but I need to see the information at project
level in a project center view in PWA.

CQ --

Why don't you create a custom filter to display negative slack according to
your requirements? And then why don't you apply the task Schedule table and
select the custom filter? How would that not meet your criteria?

I have a formula which works great, but doesn't do what I want for the
Project Summary Task. I have created a new field and called it
"NegSlack".
The formula finds any task that has negative slack and gives me the
result.
This is fine. However, what I want to see is if ANY single task has
negative
slack, the Project Summary task line to show me the negative slack result.
Instead, it calculates as well. It appears that there is no "rollup"
option
in Project Server 2007. If I make this custom field a "Project" entity
then
it doesn't even give me the option to "calculate the summary row" and if I
use my formula on a "task" entity then it doesn't give me the rollup
option -
it is either "none" or "use formula". The issue is that I can have a task
with negative slack but the overall project is not negative.
Here is the formula I am using: IIf(([Total Slack]<0),"NegSlack","Good")
What I need is some sort of modificaiton to this that says if "any task
has
total slack <0 then give me "NegSlack".
Any thoughts?