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
Click to expand...
Click to expand...
 
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
Click to expand...
Project VBA Book, for details visit:
http://www.projectvbabook.com
Click to expand...
NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx
----------------------------------------------------------------------------------------------------
Click to expand...

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
Click to expand...
Click to expand...
Click to expand...

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
Click to expand...
Project VBA Book, for details visit:
http://www.projectvbabook.com
Click to expand...
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.
Click to expand...
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")))))
Click to expand...
It works fine within the opened project plan (local) inside the
client
(I do not have enterprise global open)
Click to expand...
Am I missing some step?
Click to expand...
Thanks,
Andy Novak
Click to expand...
Click to expand...

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
Click to expand...
 

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

Similar Threads

how to stop displaying field in project professional 2007 save dia 4
Use double quotes or single quotes in formulas? 1
Why does the 2nd formula below not work correctly? 1
Custom formula to compare Baseline Finish to Current Date 1
Custom Task Progress Indicator does not work if baseline changes 1
Work, Schedule and Cost Slip formulas, help. 9
Formula with Date custom field 8
Help with Enterprise Custom Field 1

Top