Exactly why will this formula NOT import to enteprise from MSP 2007?

A

anovak

I cannot figure out why this will not import to an enterprise field.
Please help. I get the error message stating that either it
references local fields, the syntax is wrong (which I don't think it
is), or the formula references an unknown function.

IIf([Baseline Finish]=ProjDateValue("NA"),"No
baseline",IIf(ProjDateDiff([Baseline Finish],[Finish])/480>5,"Late by
more than 5 days",IIf(ProjDateDiff([Baseline Finish],[Finish])/
480>0,"Late",IIf(ProjDateDiff([Baseline Finish],[Finish])/480=0,"On
schedule",IIf(ProjDateDiff([Baseline Finish],[Finish])/480<0,"Ahead of
schedule")))))

It works fine within the opened project plan (local) inside the client
(I do not have enterprise global open)

Am I missing some step?

Thanks,
Andy Novak
 
N

NZ Projects

The limit is not restricted to 256, but I couldn't tell you what the upper
limit is.

Just tried this and works okay.

(IIf([Baseline Finish]=projdatevalue('NA'),"No
Baseline",IIf(ProjDateDiff([Baseline Finish],[Finish])/480>5,"Late by more
than 5 days",IIf(ProjDateDiff([Baseline
Finish],[Finish])/480>0,"Late",IIf(ProjDateDiff([Baseline
Finish],[Finish])/480<0,"Ahead of
schedule","On Schedule")))))

I changed the double quotes for single quote around ('NA') and removed the
on schedule argument.

HTH


Rod Gill said:
You have more than 256 characters. Does a cut down version (<256) work?

--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx


----------------------------------------------------------------------------------------------------


I cannot figure out why this will not import to an enterprise field.
Please help. I get the error message stating that either it
references local fields, the syntax is wrong (which I don't think it
is), or the formula references an unknown function.

IIf([Baseline Finish]=ProjDateValue("NA"),"No
baseline",IIf(ProjDateDiff([Baseline Finish],[Finish])/480>5,"Late by
more than 5 days",IIf(ProjDateDiff([Baseline Finish],[Finish])/
480>0,"Late",IIf(ProjDateDiff([Baseline Finish],[Finish])/480=0,"On
schedule",IIf(ProjDateDiff([Baseline Finish],[Finish])/480<0,"Ahead of
schedule")))))

It works fine within the opened project plan (local) inside the client
(I do not have enterprise global open)

Am I missing some step?

Thanks,
Andy Novak
 
A

anovak

The limit is not restricted to 256, but I couldn't tell you what the upper
limit is.

Just tried this and works okay.

(IIf([Baseline Finish]=projdatevalue('NA'),"No
Baseline",IIf(ProjDateDiff([Baseline Finish],[Finish])/480>5,"Late by more
than 5 days",IIf(ProjDateDiff([Baseline
Finish],[Finish])/480>0,"Late",IIf(ProjDateDiff([Baseline
Finish],[Finish])/480<0,"Ahead of
schedule","On Schedule")))))

I changed the double quotes for single quote around ('NA') and removed the
on schedule argument.

HTH

Rod Gill said:
You have more than 256 characters. Does a cut down version (<256) work?

Rod Gill
Project MVP
Project VBA Book, for details visit:
http://www.projectvbabook.com
NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx
----------------------------------------------------------------------------------------------------

I cannot figure out why this will not import to an enterprise field.
Please help. I get the error message stating that either it
references local fields, the syntax is wrong (which I don't think it
is), or the formula references an unknown function.
IIf([Baseline Finish]=ProjDateValue("NA"),"No
baseline",IIf(ProjDateDiff([Baseline Finish],[Finish])/480>5,"Late by
more than 5 days",IIf(ProjDateDiff([Baseline Finish],[Finish])/
480>0,"Late",IIf(ProjDateDiff([Baseline Finish],[Finish])/480=0,"On
schedule",IIf(ProjDateDiff([Baseline Finish],[Finish])/480<0,"Ahead of
schedule")))))
It works fine within the opened project plan (local) inside the client
(I do not have enterprise global open)
Am I missing some step?
Thanks,
Andy Novak

Even with what you have listed here, I continue to receive that error
message within Project Pro 2007 when attempting to add the task field
"Date Status" to the enterprise although locally the code works just
fine.

Any other suggestions? I'm open for anything and everything right
now.

Thanks,
Andy
 
G

Gary L. Chefetz [MVP]

Andy:

I wonder if the way you're using the ProjDateValue() funciton isn't part of
the problem. The more typical syntax is:

IIF(ProjDateValue([Baseline Finish])...

Just for yucks, try it.

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com


The limit is not restricted to 256, but I couldn't tell you what the
upper
limit is.

Just tried this and works okay.

(IIf([Baseline Finish]=projdatevalue('NA'),"No
Baseline",IIf(ProjDateDiff([Baseline Finish],[Finish])/480>5,"Late by
more
than 5 days",IIf(ProjDateDiff([Baseline
Finish],[Finish])/480>0,"Late",IIf(ProjDateDiff([Baseline
Finish],[Finish])/480<0,"Ahead of
schedule","On Schedule")))))

I changed the double quotes for single quote around ('NA') and removed
the
on schedule argument.

HTH

Rod Gill said:
You have more than 256 characters. Does a cut down version (<256) work?

Rod Gill
Project MVP
Project VBA Book, for details visit:
http://www.projectvbabook.com
NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx

I cannot figure out why this will not import to an enterprise field.
Please help. I get the error message stating that either it
references local fields, the syntax is wrong (which I don't think it
is), or the formula references an unknown function.
IIf([Baseline Finish]=ProjDateValue("NA"),"No
baseline",IIf(ProjDateDiff([Baseline Finish],[Finish])/480>5,"Late by
more than 5 days",IIf(ProjDateDiff([Baseline Finish],[Finish])/
480>0,"Late",IIf(ProjDateDiff([Baseline Finish],[Finish])/480=0,"On
schedule",IIf(ProjDateDiff([Baseline Finish],[Finish])/480<0,"Ahead
of
schedule")))))
It works fine within the opened project plan (local) inside the
client
(I do not have enterprise global open)
Am I missing some step?
Thanks,
Andy Novak

Even with what you have listed here, I continue to receive that error
message within Project Pro 2007 when attempting to add the task field
"Date Status" to the enterprise although locally the code works just
fine.

Any other suggestions? I'm open for anything and everything right
now.

Thanks,
Andy
 

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

Top