I am try to round the expression below on carto but it still returns no decimal places. The columns are 'number' type. I have also tried SELECT round( CAST(column as numeric), 2 ) suggested here but no decimals either.
ROUND((COUNT(*) filter (where religion = 'Orthodox Christian')) 100/ (COUNT() ),2) as orth_chri
FROM dataset_1 GROUP BY name