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! Go to Solution.
@Olivia_Bryanne_Zank1
Can you try with:
([First Number] * 1.00) / [Second Number]
User | Count |
---|---|
28 | |
14 | |
3 | |
3 | |
3 |