Blank values on EPM Server

[ashT]

Hi, I tested a formula to calculate the Planned % complete on an offline
project. It worked fine, then I added that formula to the Enterprise fields
in Enterprise Global. Now when I add that field to a view, it shows blank.
Can you help me?

This the formula i used:
IIf([Baseline Finish]<=now(),"100",IIf([Baseline
Start]>now(),0,int(0.5+100*(ProjDateDiff([Baseline Start],now())/[Baseline
Duration])))) & "%"

 

[reza]

asht--

Did you already publish your project???
hope this help

 

[ashT]

The projects on the server were published before i applied the formula. Would
that make any difference?
Do I need to republish the projects?

asht--

Did you already publish your project???
hope this help

Hi, I tested a formula to calculate the Planned % complete on an offline
project. It worked fine, then I added that formula to the Enterprise fields
in Enterprise Global. Now when I add that field to a view, it shows blank.
Can you help me?

This the formula i used:
IIf([Baseline Finish]<=now(),"100",IIf([Baseline
Start]>now(),0,int(0.5+100*(ProjDateDiff([Baseline Start],now())/[Baseline
Duration])))) & "%"

 

[ashT]

I tried publishing a new test project after the formula was applied on the
server. But still it shows Blank.

I have used Enterprise Task Text2 for the formula.

The projects on the server were published before i applied the formula. Would
that make any difference?
Do I need to republish the projects?

asht--

Did you already publish your project???
hope this help

Hi, I tested a formula to calculate the Planned % complete on an offline
project. It worked fine, then I added that formula to the Enterprise fields
in Enterprise Global. Now when I add that field to a view, it shows blank.
Can you help me?

This the formula i used:
IIf([Baseline Finish]<=now(),"100",IIf([Baseline
Start]>now(),0,int(0.5+100*(ProjDateDiff([Baseline Start],now())/[Baseline
Duration])))) & "%"

 

[ashT]

Hi,
I Opened a project from the EPM Web access, and Manually added the
customized field to the Project. Now it shows #ERROR in the cells. But there
is no info on the error. How do I get more info on the error?

However, If I add another field on the local copy, i.e. not the enterprise
field, using the the identical formula, it shows correct values.

pls help.

The projects on the server were published before i applied the formula. Would
that make any difference?
Do I need to republish the projects?

asht--

Did you already publish your project???
hope this help

Hi, I tested a formula to calculate the Planned % complete on an offline
project. It worked fine, then I added that formula to the Enterprise fields
in Enterprise Global. Now when I add that field to a view, it shows blank.
Can you help me?

This the formula i used:
IIf([Baseline Finish]<=now(),"100",IIf([Baseline
Start]>now(),0,int(0.5+100*(ProjDateDiff([Baseline Start],now())/[Baseline
Duration])))) & "%"

 

[Dale Howard [MVP]]

ashT --

Open each enterprise project and press the F9 function key to recalculate
the project. The system should now show a value, rather than #ERROR in the
field. Then publish each project as well. Hope this helps.

Hi,
I Opened a project from the EPM Web access, and Manually added the
customized field to the Project. Now it shows #ERROR in the cells. But
there
is no info on the error. How do I get more info on the error?

However, If I add another field on the local copy, i.e. not the enterprise
field, using the the identical formula, it shows correct values.

pls help.

The projects on the server were published before i applied the formula.
Would
that make any difference?
Do I need to republish the projects?

asht--

Did you already publish your project???
hope this help

:

Hi, I tested a formula to calculate the Planned % complete on an
offline
project. It worked fine, then I added that formula to the Enterprise
fields
in Enterprise Global. Now when I add that field to a view, it shows
blank.
Can you help me?

This the formula i used:
IIf([Baseline Finish]<=now(),"100",IIf([Baseline
Start]>now(),0,int(0.5+100*(ProjDateDiff([Baseline
Start],now())/[Baseline
Duration])))) & "%"

 

[Andrew Lavinsky]

Try using the [Current Date] field instead of now(). Current Date is a project
level field, that's updated on publish (not in real time). I haven't tried
your formula with that variable, but it probably should work.

-A

 

[Gary L. Chefetz]

AshT:

Try hitting F9 to recalculate the project first. You also need to detect for
a baseline, because if none exists, your current formula would return an
error.

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com

Hi,
I Opened a project from the EPM Web access, and Manually added the
customized field to the Project. Now it shows #ERROR in the cells. But
there
is no info on the error. How do I get more info on the error?

However, If I add another field on the local copy, i.e. not the enterprise
field, using the the identical formula, it shows correct values.

pls help.

The projects on the server were published before i applied the formula.
Would
that make any difference?
Do I need to republish the projects?

asht--

Did you already publish your project???
hope this help

:

Hi, I tested a formula to calculate the Planned % complete on an
offline
project. It worked fine, then I added that formula to the Enterprise
fields
in Enterprise Global. Now when I add that field to a view, it shows
blank.
Can you help me?

This the formula i used:
IIf([Baseline Finish]<=now(),"100",IIf([Baseline
Start]>now(),0,int(0.5+100*(ProjDateDiff([Baseline
Start],now())/[Baseline
Duration])))) & "%"

 

[Tomasz]

I have the same problem. Did you resolve this issue? None of the above
solutions worked for me.
Tomasz

Hi,
I Opened a project from the EPM Web access, and Manually added the
customized field to the Project. Now it shows #ERROR in the cells. But there
is no info on the error. How do I get more info on the error?

However, If I add another field on the local copy, i.e. not the enterprise
field, using the the identical formula, it shows correct values.

pls help.

The projects on the server were published before i applied the formula. Would
that make any difference?
Do I need to republish the projects?

asht--

Did you already publish your project???
hope this help

:

Hi, I tested a formula to calculate the Planned % complete on an offline
project. It worked fine, then I added that formula to the Enterprise fields
in Enterprise Global. Now when I add that field to a view, it shows blank.
Can you help me?

This the formula i used:
IIf([Baseline Finish]<=now(),"100",IIf([Baseline
Start]>now(),0,int(0.5+100*(ProjDateDiff([Baseline Start],now())/[Baseline
Duration])))) & "%"