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-
**FYI: the format data option doesn’t help-
I was able to replicate the behavior and unfortunately in SPICE currently not able to work around it.
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 types - which SHOULD help resolve this.
Have looped in @emilyzhu from product to hopefully get some more info.
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 @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 type.
For now, you can try to use Direct Query mode, which will honor your data source capability for decimal places.
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.