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.
Solved! Go to 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.
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.
User | Count |
---|---|
38 | |
28 | |
24 | |
17 | |
14 |