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	3932	May 14, 2025
Not getting accurate output in Quicksight while multiplying 2 columns Q&A developer , error , quick-sight	3	79	August 9, 2024
Rounding Issue Q&A developer , quick-sight	7	130	October 14, 2026
Quick Sight automatically rounding to 1 decimal after a division Q&A formatting , feature-request , quick-sight , calculations	12	1240	April 25, 2023
% decimal points Q&A filters , formatting , quick-sight , calculations , Business-Intelligence-Engineer	17	513	December 14, 2023

Increase decimal precision for percentages

Related topics