Skip to main content
Waters

In UNIFI, an "Error in Formula" appears when modifying a custom field - WKB11960

Article number: 11960

SYMPTOMS

  • While in the Custom Formula Editor within an Analysis (by going to Edit -- > Custom Formula), changing a number value in the formula brings the following error message: "Error in Formula. The formula contains a syntax error at character position XX:XXX cannot be used after X. Ensure all required parameters have been entered". (Xs are numbers used in the specific formula. See a specific example below:

  • Changing the value from 2000 to 3000 in the formula IF(FIND(Item name, "UR"),10000,2000) and clicking on the Save Formula icon yields this error:

ENVIRONMENT

  • UNIFI 1.8.2

CAUSE

Incorrect data entry

FIX or WORKAROUND

Avoid the error by deleting the original value entirely and adding the full replacement, instead of changing only the first integer of the original value.

ADDITIONAL INFORMATION

 

Not able to find a solution? Click here to request help.