Article ID: 927606
Article Last Modified on 2/7/2007
APPLIES TO
- Microsoft Office Project Professional 2007
SYMPTOMS
Consider the following scenario. You use Microsoft Office Project Web Access to create a new enterprise custom field definition. In the enterprise custom field definition, you enter a formula that resembles the following example:
IIf([Duration] > 0; "Yes"; "No")
In this scenario, when you try to edit the new formula, you receive the following error message:
When you view the formula, the formula is not displayed correctly. Additionally the formula is missing field names. The example formula will appear as follows:
IIf([MSPJ188743709] > 0; "Yes"; "No")
CAUSE
This problem occurs if the formula does not contain a comma as a list separator. This problem also occurs if you do not use a comma as a list separator when you edit a new or existing formula. In this case, when you save the formula, the formula is corrupted.
This problem occurs if the List Separator value is not a comma in the Regional and Language Options in Control Panel.
WORKAROUND
To work around this problem, change the List Separator value to a comma in the Regional and Language Options. To do this, follow these steps:
- Click Start, click Control Panel, and then double-click Regional and Language Options.
- On the Regional Options tab, click Customize.
- In the Customize Regional Options dialog box, click the comma in the List Separator list, and then click OK two times.
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Additional query words: PRJ2007 Project2007
Keywords: kbtshoot kbprb kbexpertiseinter KB927606