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 a way to change that to 4? Check image below- [image] **FYI: the format data option doesn’t help- [image]

HI @Ops_Expert , the rounding is happening in SPICE since we currently support fixed (18,4) decimal datatype. As Ramon mentioned, we are working to enable FLOAT type, which would allow in total 16 digit but with a floating decimal point. It will provide much wider flexibility to store numerial data…

Hi @Ops_Expert I was able to replicate the behavior and unfortunately in SPICE currently not able to work around it. Two things 1- if you have a database, you could overcome this by doing the math in the DB, with some custom SQL 2- We are working on functionality in SPICE to support FLOAT data t…

Unfortunately, I have to do the calculations on the fly because of multi-level aggregations by totals on the dashboard (pre-calculated values are just summaries of individual rows which isn’t correct for my use case) I appreciate the action item you mentioned

Hi @Ramon_Lopez and @emilyzhu , are there any updates on enabling FLOAT dtypes in SPICE? When is the expected roll-out?

Hi @Nicolas Beta/preview very soon. Please Direct Message me (in private) you Quick Sight account name + account number + email and i can add you to the preview so when it comes out you can test it out. thanks! Ramon

Hi @Ramon_Lopez - I’m working with a lot of blockchain data which requires both very large numbers but also handling of a lot of decimal places. I am bumping into the 18,4 issue everywhere… would welcome an opportunity to beta test a version of SPICE that can handle such data. Thanks in advance!

@Ramon @emilyzhu Hello, Do you have any update on when the SPICE is going to allow float ? Thanks,

Hi @helene.besancon Not sure if you have already connected with Ramon. If not, you may want to Direct Message @Ramon_Lopez following the protocols he lists above to see if you can be added to the preview.

Hi @helene.besancon Please DIRECT MESSAGE me your accountID, account name, region and description of the use case and happy to add you to the preview. thanks! Ramon Lopez

Hi Ramon, This is also a feature that is highly appreciated within my organisation. Is the preview in a seperate environment, or will it be enabled within my quicksight environment?

Quicksight - Rounding to 2 decimals

Q&A

Ops_Expert November 8, 2022, 9:35pm 5

I only use direct SPICE import for analysis, as direct import isn’t allowed due to privacy concerns. I was able to just use multiplication by 100.0000 with number format and it works fine. Though, I do hope the feature is released soon.

How to load long decimal data (> 10 digit) in quick sight

Topic		Replies	Views
Decimals rounding in SPICE Q&A developer , error , quick-sight	2	123	March 14, 2025
Increase decimal precision for percentages Q&A quick-sight , calculations	8	2497	October 28, 2024
Not getting accurate output in Quicksight while multiplying 2 columns Q&A developer , error , quick-sight	3	79	August 9, 2024
Calculations introducing extra decimal places Q&A quick-sight , calculations	10	3305	January 23, 2025
Quick Sight automatically rounding to 1 decimal after a division Q&A formatting , feature-request , quick-sight , calculations	12	1240	April 25, 2023

Quicksight - Rounding to 2 decimals

Related topics