The custom field could not be saved due to the following reason(s):This formula contains errors. Cor

T

Tanzim Akhtar

Hello,

Environment: Project Server 2010, Project Professional 2010 (Trial),
My Operating System is Windows 7, Server is Windows Server 2008 R2,
Browser is IE9, Project Web Application created in Arabic but I am
using English language for my browser for Administration.
Custom field info: Project level, Type is Text, Show Data (No
graphic).

I am trying to create a very simple formula but it doesn't get
accepted from PWA and throws the following error:
The custom field could not be saved due to the following reason(s):
•This formula contains errors. Correct the formula and try again.

Following are getting accepted [NO PROBLEM]:
o) CDbl([Finish Variance] / [Minutes Per Day])
o) [Finish Variance] / [Minutes Per Day]
o) [Finish Variance]

Following are throwing error (especially adding IIF) [PROBLEM]:
o) IIf(CDbl([Finish Variance] / [Minutes Per Day]) <=10, "On
Schedule", Off Schedule")
o) IIf(CLng([Finish Variance] / [Minutes Per Day]) <=10, "On
Schedule", Off Schedule")
o) IIf([Finish Variance] / [Minutes Per Day] <=10, "On Schedule", Off
Schedule")

Moreover, I am not able to create Project level custom field through
Project Professional 2010 however I am able to create Task/Resource
custom fields. Is this by design or what?

Thank you and
Regards
Tanzim Akhtar
 
T

Tanzim Akhtar

The issue has been resolved, alhamdulillaah.
I didn't know that you have to enter a semi colon instead of comma
when using IIF() in PWA 2010.

The resolution was to add a semi colon (;) instead of comma (,). Hence
the formulas that were throwing errors were resolved in the following
way:
o) IIf(CDbl([Finish Variance] / [Minutes Per Day]) <=10; "On
Schedule"; Off Schedule")
o) IIf(CLng([Finish Variance] / [Minutes Per Day]) <=10; "On
Schedule"; Off Schedule")
o) IIf([Finish Variance] / [Minutes Per Day] <=10; "On Schedule"; Off
Schedule")

However, I am still wondering if the custom field for Project level
can be created from Project Professional 2010 (to be added to the
enterprise).
 

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