Skip to content
ProjectControls.com
Microsoft Project

Formula editor shows error with correct formula

In the Open Standard
Jhorbam Baena OrozcoMember for 17 years 1 month
Created
7
5
0
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
Save Follow Follow forum Report
Reply New topic

7 replies

Oldest first
  1. 0
    Rafael Davila ·
    #1

    Try substituting “|” with a

    Try substituting “|” with a comma “,”.

    Report
  2. 0
    Jhorbam Baena Orozco ·
    #2

    Hi Rafael, I did it but still

    Hi Rafael, I did it but still the error keeps appearing.
     
    As I indicated, I have other schedules with fields that I have formulated myself but when opening them in this version that they installed me (MS Project Professional 2016 in Windows 10 Home Single Language), now that the laptop is formatted it generates that error and does not let me create or edit formulas.
     
    In these schedules they work well if I don't edit the formulas, that is, they are well generated; But if I enter the editor and click on the edit text box, and then click OK without modifying anything, puff the error is generated in a functional formula.
     
    In my Regional settings the Pipe is my list separator, therefore I don't see the error.
    Report
  3. 0
    Jhorbam Baena Orozco ·
    #3

    Sorry, the comment was

    Sorry, the comment was duplicated and I had to edit it
    Report
  4. 0
    Rafael Davila ·
    #4

    I do no longer use MS Project

    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.

    Report
  5. 0
    Jhorbam Baena Orozco ·
    #5

    Thank you for your answer, I

    Thank you for your answer, I will read it and try ... then I will comment on the results

    Report
  6. 0
    Jhorbam Baena Orozco ·
    #6

    Sorry din't work

    Sorry din't work

    Report
  7. 0
    Rafael Davila ·
    #7

    https://elringdepm.wordpress.

    https://elringdepm.wordpress.com/formulas/

    I see Spanish field names and comma separator, maybe this is the Key.

    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?