Absence carryover fastformula
Summary:
We integrate oracle HCM with Ramco payroll using GPI . If any employee have negative balance at year end , it should be sent to payroll for deduction and should not carryover to next year .
Our carryover rule is maximum 8 days should carryover to next year . Negative balance should not carryover next year. We have used below fast formula but it is not working
Content (please ensure you mask any confidential information):
INPUTS ARE IV_ABSENCE_BALANCE
DEFAULT FOR IV_ABSENCE_BALANCE IS 0
carryover = 0
IF IV_ABSENCE_BALANCE > 0 THEN
carryover = LEAST(IV_ABSENCE_BALANCE, 8)
RETURN carryover
Version (include the version you are using, if applicable):