? for Dale / Gary re: msprojectexperts Stoplight "how to entry"

[anovak]

Dale / Gary,

Based on your "how to" entry:

http://www.projectserverexperts.com/Shared Documents/CreateStoplightIndicators.htm

What is the easiest way to trap for "No Baseline" using the approach
you folks used in the above?

Thanks
Andy Novak

University of North Texas
Computing & Information Technology Center

 

[Dale Howard [MVP]]

Andy --

In your formula, include the following:

IIF(ProjDateValue

 

[Dale Howard [MVP]]

Andy --

In your formula, use something like this:

IIF([Baseline Start] = ProjDateValue("NA"), Truepart, Falsepart)

Hope this helps.

 

[anovak]

Gary / Dale,

For "True Part", I use "9999d" and for "False Part" I use [Finish
Variance]

Then I have a white graphical indicator if "9999d" otherwise, I use
the other indicators you have in the instructions.

Only issue is when you hold the mouse over the stoplight, you see
"9999d" which doesn't make any sense to most people. I guess its just
a matter of education.

Is this as good as one can get with this approach.

Thanks,
Andy

Andy--

In your formula, use something like this:

IIF([Baseline Start] = ProjDateValue("NA"), Truepart, Falsepart)

Hope this helps.

--
Dale A. Howard [MVP]
Enterprise Project Trainer/Consultanthttp://www.msprojectexperts.comhttp://www.projectserverexperts.com
"We wrote the book on Project Server"

Dale / Gary,

Based on your "how to" entry:

What is the easiest way to trap for "No Baseline" using the approach
you folks used in the above?

University of North Texas
Computing & Information Technology Center

 

[Dale Howard [MVP]]

Andy --

If you are using a Duration field with the formula, then yes, that is as
good as it gets. Have you considered using a Text field instead of a
Duration field? That would give you more flexibility for the True part of
the formula. Hope this helps.

Gary / Dale,

For "True Part", I use "9999d" and for "False Part" I use [Finish
Variance]

Then I have a white graphical indicator if "9999d" otherwise, I use
the other indicators you have in the instructions.

Only issue is when you hold the mouse over the stoplight, you see
"9999d" which doesn't make any sense to most people. I guess its just
a matter of education.

Is this as good as one can get with this approach.

Thanks,
Andy

Andy--

In your formula, use something like this:

IIF([Baseline Start] = ProjDateValue("NA"), Truepart, Falsepart)

Hope this helps.

--
Dale A. Howard [MVP]
Enterprise Project
Trainer/Consultanthttp://www.msprojectexperts.comhttp://www.projectserverexperts.com
"We wrote the book on Project Server"

Dale / Gary,

Based on your "how to" entry:

What is the easiest way to trap for "No Baseline" using the approach
you folks used in the above?

University of North Texas
Computing & Information Technology Center

 

[anovak]

Dale,

Once I switch to using a Text field using your existing technique (to
accomodate "No Baseline"), the [Finish Variance] is displayed as
(For example) 1920 minutes instead of 4 days.

What function can I use with the [Finish Variance] expression so that
its displayed in a text field as "4 days" instead of "1920" (minutes)?

Thanks,
Andy

Andy--

If you are using a Duration field with the formula, then yes, that is as
good as it gets. Have you considered using a Text field instead of a
Duration field? That would give you more flexibility for the True part of
the formula. Hope this helps.

--
Dale A. Howard [MVP]
Enterprise Project Trainer/Consultanthttp://www.msprojectexperts.comhttp://www.projectserverexperts.com
"We wrote the book on Project Server"

Gary / Dale,

For "True Part", I use "9999d" and for "False Part" I use [Finish
Variance]

Then I have a white graphical indicator if "9999d" otherwise, I use
the other indicators you have in the instructions.

Only issue is when you hold the mouse over the stoplight, you see
"9999d" which doesn't make any sense to most people. I guess its just
a matter of education.

Is this as good as one can get with this approach.

Thanks,
Andy

Andy--
In your formula, use something like this:
IIF([Baseline Start] = ProjDateValue("NA"), Truepart, Falsepart)
Hope this helps.
--
Dale A. Howard [MVP]
Enterprise Project
Trainer/Consultanthttp://www.msprojectexperts.comhttp://www.projectserverexperts.com
"We wrote the book on Project Server"

Dale / Gary,
Based on your "how to" entry:
http://www.projectserverexperts.com/Shared Documents/CreateStopligh...
What is the easiest way to trap for "No Baseline" using the approach
you folks used in the above?
Thanks
AndyNovak
University of North Texas
Computing & Information Technology Center

 

[Dale Howard [MVP]]

Andy --

By default, Project Server 2003 measures both Duration and Work in minutes.
You have to convert the numbers to either days or hours by dividing by 60
(to convert to hours) or by 480 (to convert to days). Hope this helps.

Dale,

Once I switch to using a Text field using your existing technique (to
accomodate "No Baseline"), the [Finish Variance] is displayed as
(For example) 1920 minutes instead of 4 days.

What function can I use with the [Finish Variance] expression so that
its displayed in a text field as "4 days" instead of "1920" (minutes)?

Thanks,
Andy

Andy--

If you are using a Duration field with the formula, then yes, that is as
good as it gets. Have you considered using a Text field instead of a
Duration field? That would give you more flexibility for the True part
of
the formula. Hope this helps.

--
Dale A. Howard [MVP]
Enterprise Project
Trainer/Consultanthttp://www.msprojectexperts.comhttp://www.projectserverexperts.com
"We wrote the book on Project Server"

Gary / Dale,

For "True Part", I use "9999d" and for "False Part" I use [Finish
Variance]

Then I have a white graphical indicator if "9999d" otherwise, I use
the other indicators you have in the instructions.

Only issue is when you hold the mouse over the stoplight, you see
"9999d" which doesn't make any sense to most people. I guess its just
a matter of education.

Is this as good as one can get with this approach.

On Feb 26, 5:03 pm, "Dale Howard [MVP]"
<dale(dot)howard(at)msprojectexperts(dot)com> wrote:
Andy--

In your formula, use something like this:

IIF([Baseline Start] = ProjDateValue("NA"), Truepart, Falsepart)

Hope this helps.

--
Dale A. Howard [MVP]
Enterprise Project
Trainer/Consultanthttp://www.msprojectexperts.comhttp://www.projectserverexperts.com
"We wrote the book on Project Server"

Dale / Gary,

Based on your "how to" entry:

What is the easiest way to trap for "No Baseline" using the approach
you folks used in the above?

University of North Texas
Computing & Information Technology Center