Hello, I’m new to Redash, my query is very simple, I need to calculate the difference value as decimal
However, I found out Redash always display as 0.00 for this particular field. I also noticed whenever the result is < 1, it shows 0.00. The rouding decimal also not correct, the 2 decimal always showing as .00
ROUND((currentdataset.num_total-olddataset.num_total)/olddataset.num_total, 2) AS difference
very appreciate if any of you can provide a quick tips how to calculate this field correctly in redash table. I no need the data for visualization.