Custom Column Percentage

I am currently trying to add a custom column that is a percentage (Col1 / Col2) of other columns. Both those columns are Quantity types, but I can’t seem to get them to show any decimal values. I only get 0 or 1 for 100%, nothing in between. Is there another type I should change it to?

Or is this something I can only do in SQL?

Hi @wisosim
It sounds like you might be seeing this issue - there’s a workaround if you read the comments:
https://github.com/metabase/metabase/issues/8783 - upvote by clicking :+1: on the first post