Formula syntax error
Written by
Updated at July 9, 2025
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.
Here is an example:
-
Invalid value list provided:
- Incorrect formula:
[field] NOT IN {'value1', 'value2'}
. - Correct formula:
[field] NOT IN ('value1', 'value2')
.
- Incorrect formula:
-
Unbalanced quotes:
- Incorrect formula:
[field] = 'value
. - Correct formula:
[field] = 'value'
.
- Incorrect formula:
-
Invalid comparison syntax:
- Incorrect formula:
[field] == 'value'
. - Correct formula:
[field] = 'value'
.
- Incorrect formula: