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.
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.
1 Like