About Percentage expression

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 Solved
0 2 108
1 ACCEPTED SOLUTION

Thank you for the reply !!!
I fixed it by using “Decimal” not “Number” according to your comments.

View solution in original post

2 REPLIES 2

Steve
Participant V

Thank you for the reply !!!
I fixed it by using “Decimal” not “Number” according to your comments.

Top Labels in this Space