Absence carryover fastformula — Cloud Customer Connect
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

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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