Custom Field Formula error

[projectserverdragon]

I am getting an error on this formula... any ideas?

IIf(([CV%]<0%),"G",(IIf((([CV%]>0%) And
([CV%]<10%)),"Y",(IIf(([CV%]<10%),"R"," - ")))))

thansk,
PSD

 

[Dale Howard [MVP]]

PSD --

I assume you are using a custom enterprise Text field, correct? If so, then
take out the percent signs (%) in the numbers you are testing. The revised
formula should be:

IIf(([CV%]<0),"G",(IIf((([CV%]>0) And
([CV%]<10)),"Y",(IIf(([CV%]<10),"R"," - ")))))

Does this give you the result you seek? Let us know and we will try to
help.

 

[projectserverdragon]

Yes sir, EntText36 to be exact.
I tried w/out the % the first run and ended in error.

Both statements are syntactically correct so they're accepted; however in
play they return "#ERROR"

Maybe a datatype issue? I can't find a log with this level of detail.
I will keep pluggin away until I figure it out and reply back.

Is there a best practice for defining a projects Budget Health other than
measuring cost variance?

Thanks for all that you do for this community!

PSD

PSD --

I assume you are using a custom enterprise Text field, correct? If so, then
take out the percent signs (%) in the numbers you are testing. The revised
formula should be:

IIf(([CV%]<0),"G",(IIf((([CV%]>0) And
([CV%]<10)),"Y",(IIf(([CV%]<10),"R"," - ")))))

Does this give you the result you seek? Let us know and we will try to
help.

I am getting an error on this formula... any ideas?

IIf(([CV%]<0%),"G",(IIf((([CV%]>0%) And
([CV%]<10%)),"Y",(IIf(([CV%]<10%),"R"," - ")))))

thansk,
PSD

 

[Dale Howard [MVP]]

PSD --

If you create a new custom enterprise field and you already have existing
projects in the Project Server database, then the PMs must open each
project, press the F9 function key to recalculate the project, and then save
and publish their projects. Out of curiosity, if you add the new custom
field to an existing project, do the #Error messages go away, or do they
remain? Let us know.

Yes sir, EntText36 to be exact.
I tried w/out the % the first run and ended in error.

Both statements are syntactically correct so they're accepted; however in
play they return "#ERROR"

Maybe a datatype issue? I can't find a log with this level of detail.
I will keep pluggin away until I figure it out and reply back.

Is there a best practice for defining a projects Budget Health other than
measuring cost variance?

Thanks for all that you do for this community!

PSD

PSD --

I assume you are using a custom enterprise Text field, correct? If so,
then
take out the percent signs (%) in the numbers you are testing. The
revised
formula should be:

IIf(([CV%]<0),"G",(IIf((([CV%]>0) And
([CV%]<10)),"Y",(IIf(([CV%]<10),"R"," - ")))))

Does this give you the result you seek? Let us know and we will try to
help.




"projectserverdragon" <[email protected]>
wrote
in message news:[email protected]...

I am getting an error on this formula... any ideas?

IIf(([CV%]<0%),"G",(IIf((([CV%]>0%) And
([CV%]<10%)),"Y",(IIf(([CV%]<10%),"R"," - ")))))

thansk,
PSD

 

[projectserverdragon]

Well I should be slapped, I didn't recalculate the project after adding the
field to our global views.

Thanks again.

I am about to embark on a journey to upgrade MSPS to 2007 so we can hit the
Gateway into Portfolio Server which I just implemented. Having all the
calculation done in Project will allow us to pass the custom fields to
Portfolio Server in hopefully a smooth fashion.

Has there been much come in on Portfolio Server?

PSD --

If you create a new custom enterprise field and you already have existing
projects in the Project Server database, then the PMs must open each
project, press the F9 function key to recalculate the project, and then save
and publish their projects. Out of curiosity, if you add the new custom
field to an existing project, do the #Error messages go away, or do they
remain? Let us know.

Yes sir, EntText36 to be exact.
I tried w/out the % the first run and ended in error.

Both statements are syntactically correct so they're accepted; however in
play they return "#ERROR"

Maybe a datatype issue? I can't find a log with this level of detail.
I will keep pluggin away until I figure it out and reply back.

Is there a best practice for defining a projects Budget Health other than
measuring cost variance?

Thanks for all that you do for this community!

PSD

PSD --

I assume you are using a custom enterprise Text field, correct? If so,
then
take out the percent signs (%) in the numbers you are testing. The
revised
formula should be:

IIf(([CV%]<0),"G",(IIf((([CV%]>0) And
([CV%]<10)),"Y",(IIf(([CV%]<10),"R"," - ")))))

Does this give you the result you seek? Let us know and we will try to
help.




"projectserverdragon" <[email protected]>
wrote
in message I am getting an error on this formula... any ideas?

IIf(([CV%]<0%),"G",(IIf((([CV%]>0%) And
([CV%]<10%)),"Y",(IIf(([CV%]<10%),"R"," - ")))))

thansk,
PSD

 

[Dale Howard [MVP]]

PSD --

I need to confess my ignorance about Portfolio Server. You might want to
repost that question in the newsgroup again as a new question and let the
other take a stab at it. By the way, don't be too hard on yourself about
the F9 function key issue. I am SO USED to see the # Error message that I
always try the F9 function key first to see if that is the source of the
error! Hope this helps.

Well I should be slapped, I didn't recalculate the project after adding
the
field to our global views.

Thanks again.

I am about to embark on a journey to upgrade MSPS to 2007 so we can hit
the
Gateway into Portfolio Server which I just implemented. Having all the
calculation done in Project will allow us to pass the custom fields to
Portfolio Server in hopefully a smooth fashion.

Has there been much come in on Portfolio Server?

PSD --

If you create a new custom enterprise field and you already have existing
projects in the Project Server database, then the PMs must open each
project, press the F9 function key to recalculate the project, and then
save
and publish their projects. Out of curiosity, if you add the new custom
field to an existing project, do the #Error messages go away, or do they
remain? Let us know.




"projectserverdragon" <[email protected]>
wrote
in message news:[email protected]...

Yes sir, EntText36 to be exact.
I tried w/out the % the first run and ended in error.

Both statements are syntactically correct so they're accepted; however
in
play they return "#ERROR"

Maybe a datatype issue? I can't find a log with this level of detail.
I will keep pluggin away until I figure it out and reply back.

Is there a best practice for defining a projects Budget Health other
than
measuring cost variance?

Thanks for all that you do for this community!

PSD

:

PSD --

I assume you are using a custom enterprise Text field, correct? If
so,
then
take out the percent signs (%) in the numbers you are testing. The
revised
formula should be:

IIf(([CV%]<0),"G",(IIf((([CV%]>0) And
([CV%]<10)),"Y",(IIf(([CV%]<10),"R"," - ")))))

Does this give you the result you seek? Let us know and we will try
to
help.




"projectserverdragon" <[email protected]>
wrote
in message I am getting an error on this formula... any ideas?

IIf(([CV%]<0%),"G",(IIf((([CV%]>0%) And
([CV%]<10%)),"Y",(IIf(([CV%]<10%),"R"," - ")))))

thansk,
PSD