Hi, I was trying to create a parameter and when I use it in the calculated field for the controls then it is throwing an error saying - "The syntax of the calculated field expression is incorrect. Correct the syntax and choose create again. " Here is the syntax I have used ifelse( ${Granularity…

I was able to fix this issue. The else ‘Null’ was the issue. For some reason, the ifelse statement was not accepting null and I updated that to a column name and it got fixed. Thanks for the help.

Attached are the screenshots and I see the below error message while creating the parameter - "The syntax of the calculated field expression is incorrect. Correct the syntax and choose create again. "

Parameter syntax error

Q&A

Koushik_Muthanna June 17, 2025, 7:35am 2

@Lasya ,

Can you share a few screenshots of where you are facing the issue ? if it’s easier, you can create a sample of the same in arena

Kind regards,
Koushik

Topic		Replies	Views
Simple error in calculated field for a parameter Q&A quick-sight , filters-controls-and-parameters , calculations , Business-Intelligence-Engineer	6	165	April 5, 2024
The syntax of the calculated field expression is incorrect. Correct the syntax and choose Create again Q&A quick-sight , calculations	1	3082	November 29, 2022
How to fix the syntax error Q&A formatting , quick-sight	21	1421	April 14, 2023
Syntax error while calculating fields using ifelse() Q&A analysis , parameters , quick-sight , calculations	1	455	June 8, 2023
How to add parameter? Q&A quick-sight , calculations , Business-Intelligence-Engineer	5	92	December 3, 2025

Parameter syntax error

Related topics