Retain precision of decimal points

Question & Answer
,
1

Hello,

Can anyone help me retain precision points of a calculated field in a dataset?
I am running a basic formula to derive the calculated field, but I see that it is rounded off to 2 decimal points whereas I want to retain the precision to 6 (or more if possible). I have tried a few things to get it to work:
1 - Rounding off in the formula of the calculated field
2 - Multiplying with 1.00 - essentially trying to coerce the type to float
3 - Changing the number of decimal points - wherever possible.

But none of them have worked so far. Are there any settings etc that I can change to achieve this?
Corresponding values in Tableau and Quicksight are shared for reference:

Tableau:
image

Quicksight:
image

Many thanks in advance!

Regards,
Tanisha

1 Like
2

Hi Tanisha
Check if this is helpful to you

image
image1827×783 106 KB

3

Thanks Darshana,

I’ve tried this earlier, it gives me more zeroes to the right as defined by the number of decimal places.

image

Regards,
Tanisha

4

any update on how to solve this please ? I am also facing the same issue

5

Hi Moise,
The QS team is working on a feature release. You can follow https://issues.amazon.com/issues/SN-32725 for updates.

1 Like
7

Hi @Moise_Dakouri , we are workin on a feature to support as many as 15 decimal places with high level of calculation precision. We are now open for private preview, if you would like to test the feature, please message me offline and we can sign you up for preview. Thanks!