I’m trying to show response rates as a percentage with 3 decimal points (xx.xxx%) but it seems no matter what I try it’s only showing 2 (xx.xx0%). Calculated fields: {submitted}/{mailed}; {settled}/{mailed} Attempted: Change decimal places in number format ((1000000*{submitted})/{mailed})/10000…

Maybe it has something to do with this. [image] Quicksight - Rounding to 2 decimals Question & Answer I have a requirement where I need to display %s over 4 decimal places. But on dividing the 2 numbers, Quicksight by default truncates anything beyond 2 decimals. Is there…

Hmmm, and you’re sure you added decimal points to the value? [image]

Definitely, both in the field wells and in the field list. [image]

This does seem to be the issue. Now that I know what the problem is I can try to figure out a workaround. Direct query probably would work but would take too long simply due to the size of the query. Thanks.

Hi @john_withanh , we are working on a feature to support as many as 15 decimal places with high level of calculation precision for SPICE dataset. 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!

hello, was the decimal places issue deployed to production Quick Sight? It seems to be fixed…

Hi there @emilyzhu , My data team and I also face a similar problem causing a big trouble. When using Quick Sight to analyze certain totals, I found that the results were consistently lower than expected. Digging deeper, I realized that Quick Sight’s handling of small precision values in custom co…

Hi @sinan , Have you tried the float data type? [image] QuickSight launches FLOAT data type support for SPICE datasets

Increase decimal precision for percentages

Q&A

Max January 27, 2023, 3:56pm 4

Maybe it has something to do with this.

Topic		Replies	Views
Quicksight - Rounding to 2 decimals Q&A analysis , quick-sight , calculations	21	3850	May 14, 2025
Not getting accurate output in Quicksight while multiplying 2 columns Q&A developer , error , quick-sight	3	50	August 9, 2024
Quick Sight automatically rounding to 1 decimal after a division Q&A formatting , feature-request , quick-sight , calculations	13	1130	April 28, 2023
% decimal points Q&A filters , formatting , quick-sight , calculations , Business-Intelligence-Engineer	17	446	December 14, 2023
Availability of 20 decimal places but rounds to 4 decimal place - Calculation going wrong Q&A analysis , error , feature-request , quick-sight , calculations	3	1512	April 25, 2023

Increase decimal precision for percentages

Related topics