PS2007 Tasks show as being late when they have not started

M

Maurizio

I uploaded aout 50 pojects in Project Center. I used the Schedule Status
formula

IIf(ProjDateValue([Baseline Finish])=4294967295,"4_ No
Baseline",IIf(DateDiff("d",[Baseline Finish],[Finish])>10,"1_ 10+ Days
Late",IIf(DateDiff("d",[Baseline Finish],[Finish])>=1 And
DateDiff("d",[Baseline Finish],[Finish])<=10,"2_ 1 to 10 Days Late","3_ On
Schedule")))

Some of the projects that tasks start say 11/28/07 and end 1/08/08 are
either shown as 2_ 1 to 10 Days Late/Yellow or 1_ 10+ Days Late/Red.
 
D

Dale Howard [MVP]

Maurizio --

There are a number of problems with your formula. Instead of the formula
you used, try the following instead:

Switch([Baseline Finish]=ProjDateValue("NA"), "No Baseline", [Finish
Variance]/480>10, "10+ Days Late", [Finish Variance]/480>=1, "1 to 10 Days
Late", [Finish Variance]/480<1, "On Schedule")

The Switch function will work better for you, I believe. In my formula
above, the [Baseline Finish]=ProjDateValue("NA") text represents the best
way to test for the absence of a Baseline. The [Finish Variance] field
contains the date slippage information you seek, so you don't need to use
the DateDiff function. Because you are using a Text field, you must divide
the Finish Variance value by 480, since Finish Variance is stored in minutes
(480 = number of minutes in an 8 hour work day). The Switch function is
simply a series of tests, done in order, until the function finds a True
value. The above use of the Switch function tests for every possible
scenario, and will return a value in every situation. Also, your use of the
1_, 2_, etc. in the returned text makes the field difficult to read,
therefore, I stripped out those items from the text returned by the
function. Hope this helps.
 
M

Maurizio

Dale,

Thank you! This is perfect.
--
Maurizio Molina


Dale Howard said:
Maurizio --

There are a number of problems with your formula. Instead of the formula
you used, try the following instead:

Switch([Baseline Finish]=ProjDateValue("NA"), "No Baseline", [Finish
Variance]/480>10, "10+ Days Late", [Finish Variance]/480>=1, "1 to 10 Days
Late", [Finish Variance]/480<1, "On Schedule")

The Switch function will work better for you, I believe. In my formula
above, the [Baseline Finish]=ProjDateValue("NA") text represents the best
way to test for the absence of a Baseline. The [Finish Variance] field
contains the date slippage information you seek, so you don't need to use
the DateDiff function. Because you are using a Text field, you must divide
the Finish Variance value by 480, since Finish Variance is stored in minutes
(480 = number of minutes in an 8 hour work day). The Switch function is
simply a series of tests, done in order, until the function finds a True
value. The above use of the Switch function tests for every possible
scenario, and will return a value in every situation. Also, your use of the
1_, 2_, etc. in the returned text makes the field difficult to read,
therefore, I stripped out those items from the text returned by the
function. Hope this helps.




Maurizio said:
I uploaded aout 50 pojects in Project Center. I used the Schedule Status
formula

IIf(ProjDateValue([Baseline Finish])=4294967295,"4_ No
Baseline",IIf(DateDiff("d",[Baseline Finish],[Finish])>10,"1_ 10+ Days
Late",IIf(DateDiff("d",[Baseline Finish],[Finish])>=1 And
DateDiff("d",[Baseline Finish],[Finish])<=10,"2_ 1 to 10 Days Late","3_ On
Schedule")))

Some of the projects that tasks start say 11/28/07 and end 1/08/08 are
either shown as 2_ 1 to 10 Days Late/Yellow or 1_ 10+ Days Late/Red.
Click to expand...
Click to expand...
 
D

Dale Howard [MVP]

Maurizio --

You are more than welcome, my friend! :)




Maurizio said:
Dale,

Thank you! This is perfect.
--
Maurizio Molina


Dale Howard said:
Maurizio --

There are a number of problems with your formula. Instead of the formula
you used, try the following instead:

Switch([Baseline Finish]=ProjDateValue("NA"), "No Baseline", [Finish
Variance]/480>10, "10+ Days Late", [Finish Variance]/480>=1, "1 to 10
Days
Late", [Finish Variance]/480<1, "On Schedule")

The Switch function will work better for you, I believe. In my formula
above, the [Baseline Finish]=ProjDateValue("NA") text represents the best
way to test for the absence of a Baseline. The [Finish Variance] field
contains the date slippage information you seek, so you don't need to use
the DateDiff function. Because you are using a Text field, you must
divide
the Finish Variance value by 480, since Finish Variance is stored in
minutes
(480 = number of minutes in an 8 hour work day). The Switch function is
simply a series of tests, done in order, until the function finds a True
value. The above use of the Switch function tests for every possible
scenario, and will return a value in every situation. Also, your use of
the
1_, 2_, etc. in the returned text makes the field difficult to read,
therefore, I stripped out those items from the text returned by the
function. Hope this helps.




Maurizio said:
I uploaded aout 50 pojects in Project Center. I used the Schedule Status
formula

IIf(ProjDateValue([Baseline Finish])=4294967295,"4_ No
Baseline",IIf(DateDiff("d",[Baseline Finish],[Finish])>10,"1_ 10+ Days
Late",IIf(DateDiff("d",[Baseline Finish],[Finish])>=1 And
DateDiff("d",[Baseline Finish],[Finish])<=10,"2_ 1 to 10 Days Late","3_
On
Schedule")))

Some of the projects that tasks start say 11/28/07 and end 1/08/08 are
either shown as 2_ 1 to 10 Days Late/Yellow or 1_ 10+ Days Late/Red.
Click to expand...
Click to expand...
Click to expand...
 
V

Vadim Gerya, PMP

Really well done ! Thanks Dale!

--
Vadim Gerya, PMP


Dale Howard said:
Maurizio --

You are more than welcome, my friend! :)




Maurizio said:
Dale,

Thank you! This is perfect.
--
Maurizio Molina


Dale Howard said:
Maurizio --

There are a number of problems with your formula. Instead of the formula
you used, try the following instead:

Switch([Baseline Finish]=ProjDateValue("NA"), "No Baseline", [Finish
Variance]/480>10, "10+ Days Late", [Finish Variance]/480>=1, "1 to 10
Days
Late", [Finish Variance]/480<1, "On Schedule")

The Switch function will work better for you, I believe. In my formula
above, the [Baseline Finish]=ProjDateValue("NA") text represents the best
way to test for the absence of a Baseline. The [Finish Variance] field
contains the date slippage information you seek, so you don't need to use
the DateDiff function. Because you are using a Text field, you must
divide
the Finish Variance value by 480, since Finish Variance is stored in
minutes
(480 = number of minutes in an 8 hour work day). The Switch function is
simply a series of tests, done in order, until the function finds a True
value. The above use of the Switch function tests for every possible
scenario, and will return a value in every situation. Also, your use of
the
1_, 2_, etc. in the returned text makes the field difficult to read,
therefore, I stripped out those items from the text returned by the
function. Hope this helps.




I uploaded aout 50 pojects in Project Center. I used the Schedule Status
formula

IIf(ProjDateValue([Baseline Finish])=4294967295,"4_ No
Baseline",IIf(DateDiff("d",[Baseline Finish],[Finish])>10,"1_ 10+ Days
Late",IIf(DateDiff("d",[Baseline Finish],[Finish])>=1 And
DateDiff("d",[Baseline Finish],[Finish])<=10,"2_ 1 to 10 Days Late","3_
On
Schedule")))

Some of the projects that tasks start say 11/28/07 and end 1/08/08 are
either shown as 2_ 1 to 10 Days Late/Yellow or 1_ 10+ Days Late/Red.
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Status Indicator for No Baseline 4
Enterprise Custom Field 11

Top