IIF Statements question for Jack D MVPS.org

[Dominic Moss]

Dear Jack,

Your MVPS e-mail bounced back as being undeliverable so I am posting my
question to the Newsgroup - Given your knowledge of Project Server do you
have any examples of how to create an iif statement so that projects can be
grouped by status in a project centre view? I am looking at trying to create
something that will show how many projects are at each stage within a
methodology process - are you familiar with PRINCE, SEI CMM, UML or RUP?

--
Dominic Moss

www.projectability.co.uk

Helping people achieve more with Microsoft Project

Tel +44 8707 303 400
Fax +44 8707 303 500

 

[Brian K - Project MVP]

Dear Jack,

Your MVPS e-mail bounced back as being undeliverable so I am posting
my question to the Newsgroup - Given your knowledge of Project Server
do you have any examples of how to create an iif statement so that
projects can be grouped by status in a project centre view? I am
looking at trying to create something that will show how many
projects are at each stage within a methodology process - are you
familiar with PRINCE, SEI CMM, UML or RUP?

IIf([% Complete]=100,"Complete",IIf((ProjDateDiff( datevalue([Finish]),
Datevalue([Current Date]), [Project Calendar])/480)>4,"Late by 5 or
more",IIf((ProjDateDiff( datevalue([Finish]), Datevalue([Current
Date]), [Project Calendar])/480)>0,"Late by 1-4","Not Late")))

This one is a set of nested IIFs that will evaluate unfinished tasks
and check to see how far the current date is from the scheduled finish
date. It then places a string in the field where the formula resides
that represents the difference.

A similar formula could be used to evaluate tasks within a project for
other criteria.

Does that help at all?

--
___
Brian K
Project MVP
http://www.projectified.com

Project Server Consultant
http://www.quantumpm.com

 

[Dominic Moss]

Brian,

Thanks for the suggestion - I will give it a try. I think what I am looking
for would include reference to the WBS or maybe a custom outline code, tasks
within Top Level task 1 100%, Top level Task 2 incomplete - project status
Stage/Phase 1 complete. Does that make any sense?

--
Dominic Moss

www.projectability.co.uk

Helping people achieve more with Microsoft Project

Tel +44 8707 303 400
Fax +44 8707 303 500

Dear Jack,

Your MVPS e-mail bounced back as being undeliverable so I am posting
my question to the Newsgroup - Given your knowledge of Project Server
do you have any examples of how to create an iif statement so that
projects can be grouped by status in a project centre view? I am
looking at trying to create something that will show how many
projects are at each stage within a methodology process - are you
familiar with PRINCE, SEI CMM, UML or RUP?

IIf([% Complete]=100,"Complete",IIf((ProjDateDiff( datevalue([Finish]),
Datevalue([Current Date]), [Project Calendar])/480)>4,"Late by 5 or
more",IIf((ProjDateDiff( datevalue([Finish]), Datevalue([Current
Date]), [Project Calendar])/480)>0,"Late by 1-4","Not Late")))

This one is a set of nested IIFs that will evaluate unfinished tasks
and check to see how far the current date is from the scheduled finish
date. It then places a string in the field where the formula resides
that represents the difference.

A similar formula could be used to evaluate tasks within a project for
other criteria.

Does that help at all?

--
___
Brian K
Project MVP
http://www.projectified.com

Project Server Consultant
http://www.quantumpm.com

 

[Brian K - Project MVP]

Brian,

Thanks for the suggestion - I will give it a try. I think what I am
looking for would include reference to the WBS or maybe a custom
outline code, tasks within Top Level task 1 100%, Top level Task 2
incomplete - project status Stage/Phase 1 complete. Does that make
any sense?

Yes. I think I see where you are going. sounds like it will be cool.
Often all you need is just a simple example of a nested IIF. The first
one I ever did took me HOURS to do until I found a good example.

--
___
Brian K
Project MVP
http://www.projectified.com

Project Server Consultant
http://www.quantumpm.com