Hey, I’m working with some calculated fields inside the datasets, where I do some simple mathematics. I take the sqrt(x + y + 2*j). Which turns out good, when I’m using direct query. Once i change the query method to spice, I get this error in my analysis: [image] I can fix this by using direct q…

Thank you @Sanjeeb2022 ! After reaching out to support, we found that the problem occurred due to some calculation. The solution ended up being converted into a double by using the following calculation: Sqrt{x + y + 2 * (j^1)}

Overflow error when changing from direct query to spice

Q&A

sagmukhe August 9, 2023, 1:19pm 2

Hello @tryingMyBest - Welcome to the Community! Thank you for posting your query. Can you please go through the following threads. It seems similar problem was encountered by others as well. Hope this helps!

2 Likes

Topic		Replies	Views
Overflow on multiplication Q&A error , quick-sight , calculations	2	1834	February 3, 2023
Overflow error while performing multiplication Q&A error , quick-sight , calculations	2	1347	May 8, 2023
Can't import data from Athena to SPICE or use calculated fields on direct queries Q&A data-source , quick-sight	5	537	November 15, 2022
Rounding issue: Incorrect result when dividing in a calculated field Q&A quick-sight , calculations	3	1167	March 10, 2023
Not getting accurate output in Quicksight while multiplying 2 columns Q&A developer , error , quick-sight	3	34	August 9, 2024

Overflow error when changing from direct query to spice

Related topics