Seemingly erroneous calculation

Hi, a calculated column does not seem to work.
I created a column to calculate a simple formula: [number of positive reviews] / [number of reviews]. For the first row, it should be 1/2=0.5. Yet, when tested, it shows 0. Why and how can I correct it?
Thanks in advance.Capture d’écran 2023-05-08 à 12.05.22.png

Solved Solved
0 1 58
1 ACCEPTED SOLUTION

Please try in a decimal type column

 [number of positive reviews]*1.00 / [number of reviews]  

AppSheet does integer division on number ( integer) type columns and omits fractions.

View solution in original post

1 REPLY 1

Please try in a decimal type column

 [number of positive reviews]*1.00 / [number of reviews]  

AppSheet does integer division on number ( integer) type columns and omits fractions.

Top Labels in this Space