Custom column not showing decimal values

Hello Team Helical,

I am using Helical Insight 3.1. We are using custom column it is always showing the data in absolute numbers and not decimal values. Please help.
The backend database being used is Postgress.

Thank You
Vetegoc.

1 Like

Hi Vetegoc,

In the custom column, it might be taking the values as integer and you have to specifically specify the same as a float so that it will display the data in decimals also. Hence 55/56 * 100 the result will be an integer and not float and will not show in decimal.

Rather if you write the calculation something like 55/56 100.00 or 55.00/56 100 then the answer will be float and will show in decimal values as well. We have tried this and it’s working fine.

You can refer to this link for more information https://stackoverflow.com/questions/54487440/how-do-i-cast-as-decimal-in-postgresql

Below the image, you can refer to for more clarity (of what we have put in the custom column and whats the output).

Thank You
From Team Helical.