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 |
---|---|
43 | |
30 | |
24 | |
23 | |
13 |