Trouble with divide expression

(Tammi Canelli) #1

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?


(Levent Kulacoglu) #2

You can try with:

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

(Tammi Canelli) #3

Thank you! That seems to have worked.