[2007] The formula contains a syntax error or contains a reference to an unrecognized field

[Robert]

Hello,
I used to write a lot of formulas in Project Server 2003 without any
problem. But now I'm not able to write any simple formula in PWA 2007. All
my formulas are rejected with the error message:
"The formula contains a syntax error or contains a reference to an
unrecognized field or function name".
For example, in the basic following formula, where is the error ?
IIf( [Duration]> 10, True, False )

Thanks for your help

 

[Robert]

I forgot to specify for my example:
IIf( [Duration]> 10, True, False )
- Entity : Task
- Type : Flag

 

[Mark Everett | PMP]

I forgot to specify for my example:
IIf( [Duration]> 10, True, False )
- Entity : Task
- Type : Flag

This might help - from Microsoft:
http://msdn2.microsoft.com/en-gb/library/ms447495.aspx#pj12_EnterpriseCF_FormulasGraphicalIndicators

This will help, if it's applicable to your formula: Formula for Budget
indicators will need to be modified from 2003 to 2007 if you used the
Len function to check for a task that hasn't been baselined (i.e.
Len(Cstr([Baseline Cost])<3). This example is for a budget indicator:
Swith([Baseline Cost]<1,"No baseline",(([Cost]+1)/([Baseline Cost]
+1))>1.15,"Overbudget by 15% or more",(([Cost]+1)/([Baseline Cost]
+1))>1 And (([Cost]+1)/([Baseline Cost]+1))<1.1,"Within budget",
(([Cost]+1)/([Baseline Cost]+1))>1.1 And (([Cost]+1/([Baseline Cost]
+1))<1.15,"Overbudget between 10% and 15%")

Regards,
Mark Everett | PMP
www.quantumpm.com