Decimals rounding in SPICE

Q&A
,
1

Hi all

I hope someone will to understand the decimals rounding in QS
I am fetching data from Athena and notice the calculation differences while using the direct query and SPICE mode.

I have the FX rate field which is calculated differently depending on the defined data set mode (direct/spice):

image
image714Ă—972 47.4 KB

Is there a way of keeping all (in my case 8) decimals available, not rounded to the 4th digit?

2

Hello @AndriyShepel,

Can you try changing the type of your decimal to “Decimal-Float”

image
image1120Ă—428 13.1 KB

Please take a look at the documentation for all the details on this format.

Hope this helps!

3

This works, thank you so much!

1 Like