Virtual Column returns zero with formula

[mclallan]

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?

[Marc_Dillon]

Try:

1.0 * [Sales] / [Target]

In order to force decimal division instead of integer division.

[Steve]

Fix for expression giving 0% or missing decimal part Tips & Tricks 💡

Trying to divide two numbers to get a percentage but always getting 0? Trying to divide two numbers but losing the numbers after the decimal point? TRY THIS Convert one or both of the values in your division expression to a Decimal value, either by: (1) wrapping the value in the expression with the DECIMAL() function; (2) multiplying the value in the expression by 1.0; or (3) changing the column’s type to Decimal if suitable to the app. FOR EXAMPLE If computing a percentage from two Number co…