I divide two numbers and get zero...?

[Olivia_Bryanne1]

Hi there,

I’m trying to make a virtual column that’s a really simple division of two numbers

the first number is a count(filter(table1, condition)) formula which equals 19
the second number is count(table1) formula that equals 39

i.e. the first is a subset of the second, and I’m after the %

both of these work fine and show as they should. but when I divide the first by the second, I get 0.00, regardless of whether I set the column type as a number, a decimal, percent…

…help?