Hey guys, I’m a new user on Appsheet and would like some help using a Virtual Column with a simple formula.
I’ve created a VC called “Target %” that is the result of [column A] / [column B] and the result should return a percentage.
The formula is pretty simple: =[Sales] / [Target], and the result would return 98%, for exemplo. But some reason I don’t understand yet, the result keeps coming back as zero.
Anyone could give me some light in what I’m doing wrong?
Try:
1.0 * [Sales] / [Target]
In order to force decimal division instead of integer division.
User | Count |
---|---|
38 | |
34 | |
27 | |
23 | |
17 |