10-01-2022 03:06 AM
In SQL editor (inside SQL experience), executing expressions 1 – 0.999 gives the result 0.
10-01-2022 03:10 AM
The incorrect result is because of default rounding to format 0.00. We can implement the below solution to solve the problem. It must be applied to every individual query.
Option 1: Edit Visualisation
After clicking Edit visualization, we can change the default Number format to 0.000
Option 2: Format number
We can use the format_number function to override the default rounding format.General solution needed
Setting the default format for numbers in SQL Editor should be possible. Currently, when we go to “SQL Admin Console”, there is only the possibility to change the default date & time format.
@Lindsay Olson @Prabakar Ammeappin @Werner Stinckens @Jose Gonzalez , please pass it on as feedback if possible.
10-01-2022 03:10 AM
The incorrect result is because of default rounding to format 0.00. We can implement the below solution to solve the problem. It must be applied to every individual query.
Option 1: Edit Visualisation
After clicking Edit visualization, we can change the default Number format to 0.000
Option 2: Format number
We can use the format_number function to override the default rounding format.General solution needed
Setting the default format for numbers in SQL Editor should be possible. Currently, when we go to “SQL Admin Console”, there is only the possibility to change the default date & time format.
@Lindsay Olson @Prabakar Ammeappin @Werner Stinckens @Jose Gonzalez , please pass it on as feedback if possible.
10-01-2022 03:15 AM
10-02-2022 11:39 AM
Thank you @Prabakar Ammeappin
10-04-2022 12:24 AM
Nice find
Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections.
Click here to register and join today!
Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.