The following quicksight query is constantly giving me errors

Question & Answer
,
1

the following query is giving me errors -

ifelse(
{State} = ‘AL’ AND toDecimal({Rate}) IN (0.1639, 0.1739, 0.1808),
toDecimal({Rate}),
NULL
)

Please suggest ways /changes to remove the error

2

Hi @kb2024 and welcome to the QuickSight community!
Are you receiving any information on what type of error is occurring?

My initial thought is that it may have something to do with the ‘toDecimal’ function, I’m not aware of this being an accepted option in QuickSight (see below for options provided within calculated field menu)

image
image494×527 12 KB

What if you tried to use ‘intToDecimal’ or ‘parseDecimal’ (depending on what type of field ‘Rate’ is within your dataset.

Let me know if one of these options works for your case or if you have any additional questions!

1 Like
3

@kb2024 ,

Checking in. We have not heard back from you regarding your question. We’d still like to help. If we do not hear back in the next 3 days, we will archive the question.

Kind regards,
Koushik

4

Hi @kb2024,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!