In SQL editor (inside SQL experience), executing expressions 1 – 0.999 gives the result 0.
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
We can use the format_number function to override the default rounding format.
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.
