Enterprise Custom Field

[dleonard]

I am trying to create and Enterprise Custom field with graphical indicators
with the following 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")))

I want to create it at the project level so that I can show the indicator in
Project Centre Summary view for each project. I can create the field but it
retruns a blank and when I examine the tooltip it shows ERROR#. What am I
doing wrong?

Regards

Dan

 

[Dale Howard [MVP]]

dleonard --

Use this formula instead:

IIf([Baseline Finish] = ProjDateValue("NA"),"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")))

I tested it and it works fine without errors. Hope this helps.

 

[Ben Howard]

There is nothing wrong with the content of the formula per-se, so have you
tried implementing this in the same way as the Partner Image where the
formula was taken from, eg Project Schedule Status = [schedule status], where
shedule status is a task level custom field?

I'm assuming you are using PS2007?

 

[dleonard]

Ben,

I am using Project Server 2007 and Proj Prof 2007. However, I don't really
understand what you were saying. Can you give more explanation?

Thanks for the quick repsonses

Dan

There is nothing wrong with the content of the formula per-se, so have you
tried implementing this in the same way as the Partner Image where the
formula was taken from, eg Project Schedule Status = [schedule status], where
shedule status is a task level custom field?

I'm assuming you are using PS2007?


--
Thanks, Ben.

Please rate this post if it helped.
http://appleparkltd.spaces.live.com/

I am trying to create and Enterprise Custom field with graphical indicators
with the following 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")))

I want to create it at the project level so that I can show the indicator in
Project Centre Summary view for each project. I can create the field but it
retruns a blank and when I examine the tooltip it shows ERROR#. What am I
doing wrong?

Regards

Dan

 

[Ben Howard]

Hi,

Did Dale's formula work?
--
Thanks, Ben.

Please rate this post if it helped.
http://appleparkltd.spaces.live.com/

Ben,

I am using Project Server 2007 and Proj Prof 2007. However, I don't really
understand what you were saying. Can you give more explanation?

Thanks for the quick repsonses

Dan

There is nothing wrong with the content of the formula per-se, so have you
tried implementing this in the same way as the Partner Image where the
formula was taken from, eg Project Schedule Status = [schedule status], where
shedule status is a task level custom field?

I'm assuming you are using PS2007?


--
Thanks, Ben.

Please rate this post if it helped.
http://appleparkltd.spaces.live.com/

I am trying to create and Enterprise Custom field with graphical indicators
with the following 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")))

I want to create it at the project level so that I can show the indicator in
Project Centre Summary view for each project. I can create the field but it
retruns a blank and when I examine the tooltip it shows ERROR#. What am I
doing wrong?

Regards

Dan

 

[dleonard]

Ben,

No it didn't. Project allows me to save the Enterprise field which suggests
it accepts the syntax. However, when I open a project in Proj Pro 2007 and
look at the result of the formula in the enterprise field under Project
Information I get #ERROR.

I have created it as a Task level and Project level field with pretty much
the same result.

Regards

Dan

Hi,

Did Dale's formula work?
--
Thanks, Ben.

Please rate this post if it helped.
http://appleparkltd.spaces.live.com/

Ben,

I am using Project Server 2007 and Proj Prof 2007. However, I don't really
understand what you were saying. Can you give more explanation?

Thanks for the quick repsonses

Dan

There is nothing wrong with the content of the formula per-se, so have you
tried implementing this in the same way as the Partner Image where the
formula was taken from, eg Project Schedule Status = [schedule status], where
shedule status is a task level custom field?

I'm assuming you are using PS2007?


--
Thanks, Ben.

Please rate this post if it helped.
http://appleparkltd.spaces.live.com/



:

I am trying to create and Enterprise Custom field with graphical indicators
with the following 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")))

I want to create it at the project level so that I can show the indicator in
Project Centre Summary view for each project. I can create the field but it
retruns a blank and when I examine the tooltip it shows ERROR#. What am I
doing wrong?

Regards

Dan

 

[Dale Howard [MVP]]

Dan --

I can assure you that the formula works. However, you need to press the F9
function key to get the software to recalculate the values in this field.
You will need to require all of your PMs to do this as well to each of their
enterprise projects. Hope this helps.

Ben,

No it didn't. Project allows me to save the Enterprise field which
suggests
it accepts the syntax. However, when I open a project in Proj Pro 2007
and
look at the result of the formula in the enterprise field under Project
Information I get #ERROR.

I have created it as a Task level and Project level field with pretty much
the same result.

Regards

Dan

Hi,

Did Dale's formula work?
--
Thanks, Ben.

Please rate this post if it helped.
http://appleparkltd.spaces.live.com/

Ben,

I am using Project Server 2007 and Proj Prof 2007. However, I don't
really
understand what you were saying. Can you give more explanation?

Thanks for the quick repsonses

Dan

:

There is nothing wrong with the content of the formula per-se, so
have you
tried implementing this in the same way as the Partner Image where
the
formula was taken from, eg Project Schedule Status = [schedule
status], where
shedule status is a task level custom field?

I'm assuming you are using PS2007?


--
Thanks, Ben.

Please rate this post if it helped.
http://appleparkltd.spaces.live.com/



:

I am trying to create and Enterprise Custom field with graphical
indicators
with the following 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")))

I want to create it at the project level so that I can show the
indicator in
Project Centre Summary view for each project. I can create the
field but it
retruns a blank and when I examine the tooltip it shows ERROR#.
What am I
doing wrong?

Regards

Dan

 

[Ben Howard]

As well as following Dale's suggestion, make sure you understand the formula
and build it up peice by peice in Project. This will enable you to de-bug
your implementation. As Dale says, his formula works, and I've tested yours
in my system and it works too!
--
Thanks, Ben.

Please rate this post if it helped.
http://appleparkltd.spaces.live.com/

Dan --

I can assure you that the formula works. However, you need to press the F9
function key to get the software to recalculate the values in this field.
You will need to require all of your PMs to do this as well to each of their
enterprise projects. Hope this helps.

Ben,

No it didn't. Project allows me to save the Enterprise field which
suggests
it accepts the syntax. However, when I open a project in Proj Pro 2007
and
look at the result of the formula in the enterprise field under Project
Information I get #ERROR.

I have created it as a Task level and Project level field with pretty much
the same result.

Regards

Dan

Hi,

Did Dale's formula work?
--
Thanks, Ben.

Please rate this post if it helped.
http://appleparkltd.spaces.live.com/



:

Ben,

I am using Project Server 2007 and Proj Prof 2007. However, I don't
really
understand what you were saying. Can you give more explanation?

Thanks for the quick repsonses

Dan

:

There is nothing wrong with the content of the formula per-se, so
have you
tried implementing this in the same way as the Partner Image where
the
formula was taken from, eg Project Schedule Status = [schedule
status], where
shedule status is a task level custom field?

I'm assuming you are using PS2007?


--
Thanks, Ben.

Please rate this post if it helped.
http://appleparkltd.spaces.live.com/



:

I am trying to create and Enterprise Custom field with graphical
indicators
with the following 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")))

I want to create it at the project level so that I can show the
indicator in
Project Centre Summary view for each project. I can create the
field but it
retruns a blank and when I examine the tooltip it shows ERROR#.
What am I
doing wrong?

Regards

Dan

 

[Muhammad Imran]

I am facing the similar issue. Ben, it is not about the complexity of the formula. Even, if I try to put a simple formula like ="Testing", it returns me with the error in the field. Any help in this regard will be highly appreciated

 

[dleonard]

I think I have found the issue here. If I open a project and add my Schedule
Health enterprise field (this is what I named it) as a new column I still get
the same issue although some rows will calculate. If I resave my baseline
then the field calculates successfully. It doesn't seem to calculate
reliablywithout a new baseline being saved

 

[Ben]

Hi Muhammad,

I'm afraid you've got some bigger problems. A project text field ="testing"
will work fine. Make sure Project Pro is configured correctly to connect to
Project Server, and it's worth getting the formulas to work correctly in Pro
1st and then cut and paste them to the enterprise codes.

 

[Dale Howard [MVP]]

dleonard --

If you are writing the formula literally, as ="Testing", then this is the
source of your problem. In Microsoft Project, you do not write formulas the
same way you do in Excel. You do not use the equal sign (=) to preface your
formula, and if you need to reference another field, you must enclose the
field in square bracks, such as [Testing]. Perhaps you need to tell us more
about what kind of formula you are writing, and give us your EXACT formula,
and we will try to help you. Let us know.

Also, "me too" posts are generally not very helpful. It would be better if
you would start a new thread for your question.