I divide two numbers and get zero...?

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?

Solved Solved
0 14 2,088
1 ACCEPTED SOLUTION

@Olivia_Bryanne_Zank1
Can you try with:

([First Number] * 1.00) / [Second Number]

View solution in original post

14 REPLIES 14
Top Labels in this Space