Formula syntax error

ERR.DS_API.FORMULA.PARSE.UNEXPECTED_TOKEN

This error occurs when a calculated field contains a formula with incorrect syntax. In the chart or dataset editing interface, such fields are highlighted in red. To fix this error, check all red marked fields and revise the formulas in them.

For example:

• Invalid value list provided:

  • Incorrect formula: [field] NOT IN {'value1', 'value2'}.
  • Correct formula: [field] NOT IN ('value1', 'value2').

• Unbalanced quotes:

  • Incorrect formula: [field] = 'value.
  • Correct formula: [field] = 'value'.

• Invalid comparison syntax:

  • Incorrect formula: [field] == 'value'.
  • Correct formula: [field] = 'value'.