PWA 2007 Enterprise Custom flag field formula question

S

ST

Hi,

I'm trying to enter a formula for a custom enterprise task flag in PWA 2007,
but I'm having problem with MS Project accepting/ validating it.

IIf((([Finish]>[Deadline]) And Not ([Deadline]="NA")) And (([Duration]>0) Or
([Duration9]>0)),True,False)

The problem is that it does not like the reference to [Duration9]. Can we
not use local custom fields in formulas?

/Spiro Theopoulos.
 
B

Ben Howard

Hi ST,

I pasted your formula directly into Project Pro, and it worked a treat. I
then opened up the ECF Definition settings and pasted it into there, and came
across the same issues as yourself. Not sure what's wrong here, will try and
have another look tomorrow.
 
B

Ben Howard

But, you could use the "add field to Enterprise" button in the Custom Fields
UI within Project Pro, and then use it in a formula.
--
Thanks, Ben.

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



Gary L. Chefetz said:
ST:

You cannot reference a local custom field in an Enterprise field formula.
Hence, the error on Duration9, which is a built-in local custom field

--
----------
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


ST said:
Hi,

I'm trying to enter a formula for a custom enterprise task flag in PWA
2007,
but I'm having problem with MS Project accepting/ validating it.

IIf((([Finish]>[Deadline]) And Not ([Deadline]="NA")) And (([Duration]>0)
Or
([Duration9]>0)),True,False)

The problem is that it does not like the reference to [Duration9]. Can we
not use local custom fields in formulas?

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

Need some PWA help 0
PWA Custom Field - Date Difference 2
Formula in a 2007 Task Custom field 5
Custom Task field updates in My Timesheet 0
The custom field could not be saved due to the following reason(s):This formula contains errors. Cor 1
Calculated Enterprise custom fields [2007] 1
#Error in Enterprise Custom Fields 3
PWA not showing overall status in Project Center 2

Top