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!
PAY: Fast Formula gives Inaccurate value for the element "Normal Overtime"
My fast formula which is written for calculating the "Normal Overtime" is as follows: (shown in
double quotes)
" Nornal Overtime = round((PER_HOUR * Normal_Days_Hours)+(AB_HOUR * Holidays_Hours),0) "
where PER_HOUR = BASIC_SALARY/No_of_DAYS /8 * 3 /2
No_of_days = Number of days in any particular month.
AB_HOUR =BASIC_SALARY/No_of_DAYS /8 * 2
The issue with my fast formula is, it is not calculating the " AB_HOUR * Holidays_Hours " for eg:
Lets say, PER_HOUR = 19 & Normal_Days_Hours = 28 for an employee, whereas
AB_HOUR = 25 & Holidays_Hours = 48
So, as per the above assumption " Normal Overtime " should come as 1732 , but instead of that it is returning