Trouble with divide expression

[tcanelli]

I’m trying to get a % using virtual column, taking [Check in Totals]/[Capacity] but result keeps ending in 0. I’ve tried column types $, number, decimal - all return 0. What am I doing wrong?

[LeventK · Accepted solution]

@tcanelli
You can try with:

[Check in Totals] / ([Capacity] * 1.00)

[tcanelli]

Thank you! That seems to have worked.

[Chakorn_Chokdee]

Thank you