ERPstuff - Oracle EBS Community

Dear Sami

Try the below formula

X = (annl_sal * 0.1) - (assur)


IF X >= 1000 THEN
(
IR = (X * 0.1)
RETURN IR
)
ELSE IF X < 1000 AND X >= 2000 THEN /* X = 1800 */
(
a = (1000 * 0.1) /* a = 1000 * 0.1 = 100 */
Y = X - 1000 /* Y = 1800 - 1000 = 800 */
IR = a + (Y * 0.15) /* IR = 100 + 120 ...