Libreoffice Base version: Version: 22.214.171.124 / Build ID: 1:6.0.7-0ubuntu0.18.04.10 / HSQLDB
I have two fields “county_population” and “state_population” each formatted as double[DOUBLE]. The third field is a calculated field “county_population” / “state_population”. When I run query, the results show only two decimal places; I would like it to show six decimal places. I’ve tried using CAST as DECIMAL and I’ve tried multiplying “county_population” *1.000000 to no avail. Any ideas?