Skip to Content
Former Member
Dec 01, 2005 at 06:33 PM

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.


Ashmith Roy