Formula help

[MF Scheetz]

MS Project 2003 SP2

I have the following formula in a field:

IIf(isnull([Text8]) And [Work]=0 Or [Number6]=0 And [% Complete]=100,[%
Complete],[Number6])

It works great on the lowest level items, but on any upper level items, it
leaves [Number9] = 0 regardless of what is in [Number6].

I've tried iif(isnull([WBSSuccessor]),[Number6],IIf(isnull([Text8]) And
[Work]=0 Or [Number6]=0 And [% Complete]=100,[% Complete],[Number6]))

But this turns up the same result.

Is there any way to set all parent/upper level itmes to [Number6] while
still running the function for all the child/lowest level items?

Thanks in advance,
-Matt

 

[Jonathan Sofer]

Have you tried using different summary rolling up options like sum, max or
formula? You might have it still set to None which would explain why it is
showing zero. If you have it set to none then try formula first.

This can be found in the second section of the cutsom field definition page

Jonathan

 

[Jack Dahlgren]

Sounds like you aren't using a formula for summary rows.

Right-click the column header, select customize field, make sure that the
"Calculation for task and group summary rows" is set to "Use Formula"

-Jack Dahlgren

 

[Jim Aksel]

This is a little off topic, but to be on the safe side, you should also
consider littering the formula with plenty of parenthesis () to be sure your
logic is being applied the way you intend.

If I recall correctly, arithmetic logic takes precedence over boolean, and
then the boolean will execture left to right. Remember, with those strung
together OR you will return TRUE if any one of them is true.
--
If this post was helpful, please consider rating it.

Jim

Visit http://project.mvps.org/ for FAQs and more information
about Microsoft Project