Announcements for Payroll and OTL can now be found in the Announcements - Payroll and OTL - EBS (MOSC) subcategory. Follow to be sure you don't miss a thing!
Excluding element with zero value from Run Results
Hi Experts,
Need an urgent help.
I have 1 information element triggering 3 Indirect elements.
I want to include indirect element with value more than zero value and exclude element with zero value.
Main Element:- Leave Advance (Information element)
3 Indirect elements:-
1. Basic Leave Advance - (value = 2000)
2. Transport leave advance - (value = 0)
3. Housing leave advance - (value = 500)
So, as per the above case, we need to include only 1. Basic Leave Advance and 3. Housing leave advance in Run Results.
Below is query:-
/* (L_Basic = Leave_Adv_Days * L_basic/30
If L_Basic > 0 THEN
Return L_Basic)
(L_Transport = Leave_Adv_Days * L_transport/30