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

[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

 

[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).