Here is simple formula to get percentage.
I’d like to show percentage by using virtual column, but I could not get expected result.
expected result, 1 / 5 = 0.2 → 20.00%
actual result is, 1 / 5 = 0 → 0.00% (automatic rounddown?)
I use default settings. (for example, Decimal digits → 2)
How do I fix this ?
Solved! Go to Solution.
Thank you for the reply !!!
I fixed it by using “Decimal” not “Number” according to your comments.
Thank you for the reply !!!
I fixed it by using “Decimal” not “Number” according to your comments.
User | Count |
---|---|
59 | |
25 | |
13 | |
12 | |
6 |