Virtual Column returns zero with formula

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. image

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.

3 Likes
2 Likes