formula for "indicators" such as Schedule & Work

[Tricia R.]

I am using a "switch" formula that someone passed along to put indicators in
a custom field that show red, yellow or green based on variance to the
baseline. The problem is, if there is no baseline, I am getting a "?" in the
field. Someone suggested I use an "If" statement to do this. Can someone
please send me a formula that would test for baseline so i can add it to my
formula and show a neutral indicator instead of a "?".

My current formula is:

Switch(Len(CStr([Baseline Finish]))<3,"No Baseline",([Duration
Variance]/[Baseline Duration])>0.15,">15% Late",([Duration
Variance]/[Baseline Duration])>0,"Late",True,"On Time")

 

[Dale Howard [MVP]]

Tricia --

One approach to test to see if the baseline has been saved is as follows:

If [Baseline Finish] > 54789



If the Baseline Finish field is NA then the Baseline Finish value will be
greater than 54789. If the baseline has been saved, the value will be less
tan 54789. Hope this helps.

 

[JackD]

It should be noted here that 54789 equates to the first day of 2050. This
date is outside the range of dates that project can handle so you can use it
safely.

Another approach and one which makes more sense when you look at it later is

iif([Baseline Finish]=projdatevalue("NA"), "Has Baseline", "No, Baseline")


--
-Jack ... For project information and macro examples visit
http://masamiki.com/project

..

Tricia --

One approach to test to see if the baseline has been saved is as follows:

If [Baseline Finish] > 54789



If the Baseline Finish field is NA then the Baseline Finish value will be
greater than 54789. If the baseline has been saved, the value will be less
tan 54789. Hope this helps.

I am using a "switch" formula that someone passed along to put indicators
in
a custom field that show red, yellow or green based on variance to the
baseline. The problem is, if there is no baseline, I am getting a "?" in
the
field. Someone suggested I use an "If" statement to do this. Can someone
please send me a formula that would test for baseline so i can add it to
my
formula and show a neutral indicator instead of a "?".

My current formula is:

Switch(Len(CStr([Baseline Finish]))<3,"No Baseline",([Duration
Variance]/[Baseline Duration])>0.15,">15% Late",([Duration
Variance]/[Baseline Duration])>0,"Late",True,"On Time")

 

[Dale Howard [MVP]]

JackD --

Thanks for the additional clarification.

It should be noted here that 54789 equates to the first day of 2050. This
date is outside the range of dates that project can handle so you can use
it
safely.

Another approach and one which makes more sense when you look at it later
is

iif([Baseline Finish]=projdatevalue("NA"), "Has Baseline", "No, Baseline")


--
-Jack ... For project information and macro examples visit
http://masamiki.com/project

.

Tricia --

One approach to test to see if the baseline has been saved is as follows:

If [Baseline Finish] > 54789



If the Baseline Finish field is NA then the Baseline Finish value will be
greater than 54789. If the baseline has been saved, the value will be less
tan 54789. Hope this helps.

I am using a "switch" formula that someone passed along to put
indicators
in
a custom field that show red, yellow or green based on variance to the
baseline. The problem is, if there is no baseline, I am getting a "?" in
the
field. Someone suggested I use an "If" statement to do this. Can someone
please send me a formula that would test for baseline so i can add it
to
my
formula and show a neutral indicator instead of a "?".

My current formula is:

Switch(Len(CStr([Baseline Finish]))<3,"No Baseline",([Duration
Variance]/[Baseline Duration])>0.15,">15% Late",([Duration
Variance]/[Baseline Duration])>0,"Late",True,"On Time")

 

[Tricia R.]

Thank you both!! I will give one of these a shot!

JackD --

Thanks for the additional clarification.

It should be noted here that 54789 equates to the first day of 2050. This
date is outside the range of dates that project can handle so you can use
it
safely.

Another approach and one which makes more sense when you look at it later
is

iif([Baseline Finish]=projdatevalue("NA"), "Has Baseline", "No, Baseline")


--
-Jack ... For project information and macro examples visit
http://masamiki.com/project

.

Tricia --

One approach to test to see if the baseline has been saved is as follows:

If [Baseline Finish] > 54789



If the Baseline Finish field is NA then the Baseline Finish value will be
greater than 54789. If the baseline has been saved, the value will be less
tan 54789. Hope this helps.





I am using a "switch" formula that someone passed along to put
indicators
in
a custom field that show red, yellow or green based on variance to the
baseline. The problem is, if there is no baseline, I am getting a "?" in
the
field. Someone suggested I use an "If" statement to do this. Can someone
please send me a formula that would test for baseline so i can add it
to
my
formula and show a neutral indicator instead of a "?".

My current formula is:

Switch(Len(CStr([Baseline Finish]))<3,"No Baseline",([Duration
Variance]/[Baseline Duration])>0.15,">15% Late",([Duration
Variance]/[Baseline Duration])>0,"Late",True,"On Time")