Hi,
I am encountering the following issue:
SELECT
field1, //returns 4
field2, //returns 1
( ( field2 / field1) * 100) //this returns zero - not what I want - I am looking for 25
Am I doing something wrong with type conversion (integer/floating point)?