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))
Tagged:
0