An error with calculated field

Question & Answer
1

Hi Everyone,

I am not sure if anyone have reported this. When creating a calculated field and save, the curly brackets get lost.
Add calculated field > count({id}) > save. Click on the calculated field three dots … > Edit calculated field. See issue

count({id}) changed to count(id)

this result on having this error message: Your calculated field expression contains invalid syntax. Correct syntax and try again.

any suggestions???

2

Hi @Sam_Shamsan , the system automatically convert the curly bracket, but it shouldn’t be the reason why your syntax is not correct. Can you provide a screenshot for your calculated field?

3

Hi @Sam_Shamsan. Has this been resolved? If so, please help the community by marking the appropriate post as “Solution”. If you still need assistance, please provide additional detail. Thanks!

4

Hi @Sam_Shamsan. We have not heard back from you regarding your question. Has this been resolved? If so, please help the community by providing solution details and marking the appropriate post as “Solution”. If we do not hear back in the next 7 days, we will archive the question. Thanks for posting your questions on the QuickSight Community Q&A Forum!