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.