Custom fields in Project 2007

[Valeria Chiuki]

Hi,
I am trying to customize a field in Project 2007 using PWA and using a
number task type field and I get an error message that indicates "there is a
problem with the sysntax" . The formula is IIf([Baseline
10Work]=0;IIf([Status Date]<[Baseline10 Start];0;100);([BCWS]/[Baseline 10
Work]))
The problem is that if I try the same thing using Microsoft Project Pro, the
formula workf perfectly. The error comes when I tryed to create it with the
PWA to make it a enterprise field.
Any solution?
Thanks!

 

[Jim Aksel]

You may get a better answer posting to the Server newsgroup, this newgroup is
for the desktop verion of MS Project. That said, I have an off topic
observation in your formula

1. In the desktop version of Project, you can insert the "status" column and
it will tell you if things are late, on schedule or future task.

2. Your formula seems to be going in different directions. From what I can
tell, If Baseline 10 Work is 0 you return either 0 or 100 based on the Start
Date and the Status date. Otherwise rerturn BCWS/Baseline10 Work.

If you are assuming that Work=0 on milestones, that works ok. Wouldn't it
be better to test on Baseline10 Duration=0? That would get you milestones
for sure, but you would still have a division by 0 problem.
Otherwise you need to address the case of a task with a real duration and 0
work loaded in the baseline... not likely but possible for planning packages,
etc. For sure you do not want to indicte 100% (my assumption) based only on
a start date for a task with real duration.

BCWS is measured in monetary units, Euros, Dollars, Pounds. Work is
measured in Minutes in Project. I am not sure what dividing the two will get
you. The value returned is scheduled spend to the status date per total
baseline work minute. Is that what you wanted? Might the variable
%WorkComplete be more useful or divide BCWS by Baseline Cost which gives you
a planned percent complete.

If you are trying to do this for some type of "should be status" you may
want to look at my blog and read some of the white papers on %Complete. My
approach is different, it may or may not address your issues.

--
If this post was helpful, please consider rating it.

Jim Aksel, MVP

Check out my blog for more information:
http://www.msprojectblog.com

 

[Valeria Chiuki]

Thank you Jim.
I`ll post it int the Server newsgroup.
What I am trying to do is get something as %WorkPlanned for a given Status
date. That is I'm an trying to get a measurement of how much "late" is a task.

I'll read your blog and check your approach.
Thanks!

You may get a better answer posting to the Server newsgroup, this newgroup is
for the desktop verion of MS Project. That said, I have an off topic
observation in your formula

1. In the desktop version of Project, you can insert the "status" column and
it will tell you if things are late, on schedule or future task.

2. Your formula seems to be going in different directions. From what I can
tell, If Baseline 10 Work is 0 you return either 0 or 100 based on the Start
Date and the Status date. Otherwise rerturn BCWS/Baseline10 Work.

If you are assuming that Work=0 on milestones, that works ok. Wouldn't it
be better to test on Baseline10 Duration=0? That would get you milestones
for sure, but you would still have a division by 0 problem.
Otherwise you need to address the case of a task with a real duration and 0
work loaded in the baseline... not likely but possible for planning packages,
etc. For sure you do not want to indicte 100% (my assumption) based only on
a start date for a task with real duration.

BCWS is measured in monetary units, Euros, Dollars, Pounds. Work is
measured in Minutes in Project. I am not sure what dividing the two will get
you. The value returned is scheduled spend to the status date per total
baseline work minute. Is that what you wanted? Might the variable
%WorkComplete be more useful or divide BCWS by Baseline Cost which gives you
a planned percent complete.

If you are trying to do this for some type of "should be status" you may
want to look at my blog and read some of the white papers on %Complete. My
approach is different, it may or may not address your issues.

--
If this post was helpful, please consider rating it.

Jim Aksel, MVP

Check out my blog for more information:
http://www.msprojectblog.com

Hi,
I am trying to customize a field in Project 2007 using PWA and using a
number task type field and I get an error message that indicates "there is a
problem with the sysntax" . The formula is IIf([Baseline
10Work]=0;IIf([Status Date]<[Baseline10 Start];0;100);([BCWS]/[Baseline 10
Work]))
The problem is that if I try the same thing using Microsoft Project Pro, the
formula workf perfectly. The error comes when I tryed to create it with the
PWA to make it a enterprise field.
Any solution?
Thanks!

 

[Jim Aksel]

You will want to use Physical%Complete.
Planned%Complete=BCWS/Baseline Cost
Physical%Complete=BCWP/Baseline Cost

The world gets muddy if Start does not equal Baseline Start.

The Schedule Performance Index (SPI) will get you what you seek (compared to
baseline). It is covered well in my blog
--
If this post was helpful, please consider rating it.

Jim Aksel, MVP

Check out my blog for more information:
http://www.msprojectblog.com

Thank you Jim.
I`ll post it int the Server newsgroup.
What I am trying to do is get something as %WorkPlanned for a given Status
date. That is I'm an trying to get a measurement of how much "late" is a task.

I'll read your blog and check your approach.
Thanks!

You may get a better answer posting to the Server newsgroup, this newgroup is
for the desktop verion of MS Project. That said, I have an off topic
observation in your formula

1. In the desktop version of Project, you can insert the "status" column and
it will tell you if things are late, on schedule or future task.

2. Your formula seems to be going in different directions. From what I can
tell, If Baseline 10 Work is 0 you return either 0 or 100 based on the Start
Date and the Status date. Otherwise rerturn BCWS/Baseline10 Work.

If you are assuming that Work=0 on milestones, that works ok. Wouldn't it
be better to test on Baseline10 Duration=0? That would get you milestones
for sure, but you would still have a division by 0 problem.
Otherwise you need to address the case of a task with a real duration and 0
work loaded in the baseline... not likely but possible for planning packages,
etc. For sure you do not want to indicte 100% (my assumption) based only on
a start date for a task with real duration.

BCWS is measured in monetary units, Euros, Dollars, Pounds. Work is
measured in Minutes in Project. I am not sure what dividing the two will get
you. The value returned is scheduled spend to the status date per total
baseline work minute. Is that what you wanted? Might the variable
%WorkComplete be more useful or divide BCWS by Baseline Cost which gives you
a planned percent complete.

If you are trying to do this for some type of "should be status" you may
want to look at my blog and read some of the white papers on %Complete. My
approach is different, it may or may not address your issues.

--
If this post was helpful, please consider rating it.

Jim Aksel, MVP

Check out my blog for more information:
http://www.msprojectblog.com

Hi,
I am trying to customize a field in Project 2007 using PWA and using a
number task type field and I get an error message that indicates "there is a
problem with the sysntax" . The formula is IIf([Baseline
10Work]=0;IIf([Status Date]<[Baseline10 Start];0;100);([BCWS]/[Baseline 10
Work]))
The problem is that if I try the same thing using Microsoft Project Pro, the
formula workf perfectly. The error comes when I tryed to create it with the
PWA to make it a enterprise field.
Any solution?
Thanks!