Support is required on an issue we are facing on duration element which is being used in Forecasting formula of Absence take.
Our ultimate objective is to forecast Absence take on working days (for future and back dates) instead of Calendar days.
For that purpose, we have used Daily Absence formula in duration to return working days but somehow this formula is not working and returns 0 i.e. not returning working days in forecasting of Absence take.
Is there anything we are missing in setup? Do we need to use some other elements to get desired results?
Please suggest some solution.
---- Daily absence formula in Duration
IF SY[SCHED HRS] > 0 THEN
1 >> FM[FM COUNT WORK DAYS]
ELSE
0 >> FM[FM COUNT WORK DAYS]
ENDIF
-----------------
------------Forecasting formula in Absence take
SY[ABS BGN DATE] >> VR[GP TEMP001 DATE]
SY[ABS END DATE] >> VR[GP TEMP002 DATE]
IF DR[ASK DUR PRD DY] <= 90 THEN
IF SY[DAY COUNT PD] = 1 THEN
'ELIGIBLE' >> FM[ASK FM FORE EPO]
ELSE
'INELIGIBLEBAL' >> FM[ASK FM FORE EPO]
ENDIF
ELSE
'INELIGIBLEDUR' >> FM[ASK FM FORE EPO]
ENDIF
---------------------------
