# Retain precision of decimal points

**URL:** <https://community.amazonquick.com/t/retain-precision-of-decimal-points/5835>\
**Category:** Q&A\
**Tags:** data-source, calculations, feature-request, quick-sight\
**Created:** [September 6, 2022, 3:49pm UTC](https://community.amazonquick.com/t/retain-precision-of-decimal-points/5835 "2022-09-06T15:49:32Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Tanisha\_Shetty](https://avatars.discourse-cdn.com/v4/letter/t/e36b37/32.png) [@Tanisha\_Shetty](https://community.amazonquick.com/u/Tanisha_Shetty)\
**Post date:** [September 6, 2022, 3:49pm UTC](https://community.amazonquick.com/t/retain-precision-of-decimal-points/5835/1 "2022-09-06T15:49:32Z")

</div>

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](https://d1wl4jav5dp96l.cloudfront.net/original/2X/d/da732ca12de90363c93cd404c67bf751f7234a8c.png)

Quicksight:  
 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/4/45aee649f42ef5f05d0be2a0c92d0e54aebb75eb.png)

Many thanks in advance!

Regards,  
Tanisha

---

<div class="post-metadata">

**Author:** ![darshana.s](https://avatars.discourse-cdn.com/v4/letter/d/779978/32.png) [@darshana.s](https://community.amazonquick.com/u/darshana.s)\
**Post date:** [September 8, 2022, 6:57am UTC](https://community.amazonquick.com/t/retain-precision-of-decimal-points/5835/2 "2022-09-08T06:57:59Z")

</div>

Hi Tanisha  
Check if this is helpful to you

 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/e/e3bce557b5d05cdeb040909cd29422f19c1c7cdb.png)

---

<div class="post-metadata">

**Author:** ![Tanisha\_Shetty](https://avatars.discourse-cdn.com/v4/letter/t/e36b37/32.png) [@Tanisha\_Shetty](https://community.amazonquick.com/u/Tanisha_Shetty)\
**Post date:** [September 8, 2022, 9:27am UTC](https://community.amazonquick.com/t/retain-precision-of-decimal-points/5835/3 "2022-09-08T09:27:23Z")

</div>

Thanks Darshana,

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

![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/a/a68577e47f7d79549241decd9ecc20a61620132b.png)

Regards,  
Tanisha

---

<div class="post-metadata">

**Author:** ![Moise\_Dakouri](https://avatars.discourse-cdn.com/v4/letter/m/a183cd/32.png) [@Moise\_Dakouri](https://community.amazonquick.com/u/Moise_Dakouri)\
**Post date:** [October 3, 2022, 12:51pm UTC](https://community.amazonquick.com/t/retain-precision-of-decimal-points/5835/4 "2022-10-03T12:51:57Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Tanisha\_Shetty](https://avatars.discourse-cdn.com/v4/letter/t/e36b37/32.png) [@Tanisha\_Shetty](https://community.amazonquick.com/u/Tanisha_Shetty)\
**Post date:** [October 3, 2022, 1:30pm UTC](https://community.amazonquick.com/t/retain-precision-of-decimal-points/5835/5 "2022-10-03T13:30:42Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![DeepakS](https://avatars.discourse-cdn.com/v4/letter/d/b2d939/32.png) [@DeepakS](https://community.amazonquick.com/u/DeepakS)\
**Post date:** [October 14, 2022, 3:14pm UTC](https://community.amazonquick.com/t/retain-precision-of-decimal-points/5835/6 "2022-10-14T15:14:39Z")

</div>



---

<div class="post-metadata">

**Author:** ![emilyzhu](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/emilyzhu/32/255_2.png) [@emilyzhu](https://community.amazonquick.com/u/emilyzhu)\
**Post date:** [April 25, 2023, 4:50pm UTC](https://community.amazonquick.com/t/retain-precision-of-decimal-points/5835/7 "2023-04-25T16:50:34Z")

</div>

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!
