You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Carryover formula does not work

Summary:

if balance is -ve then it should reset to zero , if positive , it should carry forward.

Content (please ensure you mask any confidential information):

/* FORMULA_NAME : CARRYOVER_FF
   FORMULA TYPE : Global Absence Carryover */
   */
DEFAULT FOR IV_CARRYOVER IS 0

INPUTS ARE IV_CARRYOVER (NUMBER)

 
L_FORMULA_NAME = 'CARRYOVER_FF'
L_BALANCE = GET_PLAN_BALANCE('FTO')
carryover = IV_CARRYOVER
 
L_LOG = ESS_LOG_WRITE(L_FORMULA_NAME||':L_BALANCE:' ||TO_CHAR(L_BALANCE))
L_LOG = ESS_LOG_WRITE(L_FORMULA_NAME||':L_CARRYOVER:' ||TO_CHAR(carryover))


IF (L_BALANCE >0) THEN
 (
   carryover  = L_BALANCE
    L_LOG = ESS_LOG_WRITE(L_FORMULA_NAME||':INSIDE_IF_L_BALANCE:' ||TO_CHAR(L_BALANCE))

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!