Formula editor shows error with correct formula Greetings. I am writing for the following reason, my copy of MS Project fails when trying to add a formula in a numeric custom field specifically the "Number 2". I tried several times without achieving anything, even modifying the original formula. These are the formulas IIf ([Job] <> 0 | Format ([Actual Job] / [Job] | "0.00%") | "0.00%")IIf ([Work]> 0 | ([Actual Work] / [Work]) * 100 | 0) These are the names of the fields in Spanish, what they do is calculate the executed work with decimals, since project only shows integers. The error MS Project indicates is always in the first PIPE from left to right. I opened a previous file that had one of these formulas included and it works, but when opening the formula and clicking OK, the same error appears ... although the formula works in the file until the editor is opened. Captures of the error are attached ... I appreciate someone tell me that it may be happening, or if it is an additional configuration of the S.O. 
Thank you
Formula editor shows error with correct formula
Forum Sponsor
Top Posters
Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts
https://elringdepm.wordpress.com/formulas/
I see Spanish field names and comma separator, maybe this is the Key.
Sorry din't work
Thank you for your answer, I will read it and try ... then I will comment on the results
I do no longer use MS Project but in order to avoid software issues with language I always use English settings. I always use US English keyboard for similar reason. Maybe your regional settings are the source of these issues.
MSP: Install and Configure the Microsoft Project Interface
Configure Windows Regional Settings
In some cases, if you save a project with non-matching OS and application language settings, data loss can occur.
Try substituting “|” with a comma “,”.