Retool Table View Issue with Float
the main issue is that, if the value is 2.2 it shows as 2.2 only but if it's 2.0 it shows as 2 in retool table, but bigquery shows correctly as 2.0.
Is there a way I can show 2 decimal places, I tried pad and decimal places, but now working, when I do {{table1.selectedRow[<col_name>]. it show as 2 only.
?
Hii @kum,
Here is an example: When I use {{table1.selectedRow.[col_name]}} it returns a value with decimal points.
Please verify if your database stores the value as decimal points or a float.
I hope this will help you. If you have any questions, feel free to ask.
In db it's stored as float type
Update the data type to decimal and set the decimal places to 2(2.00).
