Redash on Postgres displays very small decimals as NaN

Support Usage Support
,
1

Decimals >=Ne-7 are displayed as NaN in Redash

Here I’m doing queries like

select 0.0000001::decimal; (10e-7)

And gets NaN

While select 0.000001::decimal; (10e-6)

Displays 0.00 (all good, I can fix decimal places it via Visualisation)

2

Thanks for the report. This is probably an issue with Numeral, our numbers library. We’ll need to investigate if there is an available update for it.

Meanwhile you could possibly work around it by scaling your values at the query-level.