Routine for ratio

Hi All,

I am using a update routine to calculate the commission ratio. The formula is Profit amount/Sales Revenue. But the problem is it is returning just zeroes for values.

Both Profit amount and Sales Revenue are Amount datatype KFs and Commission is a Number Data type with decimals. Is that the reason why I am returning zeroes?

Also I am using ABS(profit Amount/Sales Revenue) because sometimes Profit is negative. Or is this the reason why I getting zeroes in results.

Thanks,

Ashmith Roy