Virtual column returns only zeros

[johnathankar]

Hi everyone

I know that this has been answered left and right and I do have tried all that I could find, but despite, it is not possible to get the correct result from an expression sitting in a virtual column. 

I am essentially dividing two COUNT() functions each of which gives an integer. The result of the division can be an integer or a decimal number. Thats all.
I have tried to break the formula in two separate virtual columns and calculate the result using a third one or include them all in a single function and use only one virtual column.

The expression testing gives the expected values, however within the app I only get zeros or in the best case, I may get the correct result for a row, however it returns to 0 the minute I edit any related column.

All help welcome.

Cheers

[AleksiAlkio]

Try to add a decimal value to your calculation like..
(1.0 * COUNT(...)) / COUNT(...)