Skip to Content
avatar image
Former Member

Incorrect Attendance Bonus Calculation

Hello Experts,

I have a PCR to calculate the attendance bonus which is paid to the employees who work through the month without availing leaves and  without remaining absent (Unpaid absence/LWP).

The calculation of this bonus is based on the following formula

[(1000+1006+1016) / Total number of working days] * 2

Where 1000/1006 and 1016 are the wagetypes.

Unfortunately, my PCR is working even if the employee has not worked for the entire month. Requesting a help in correcting the same.

Below is my PCR

Harriss

AttBon.png (12.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Oct 26, 2015 at 08:27 AM

    Just to reconfirm - for mid-month joinees, attendance bonus should not be calculated?

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 26, 2015 at 08:35 AM

    You have Given condition for paid , Unpaid absences and  issue is coming in Else condition , When you are saying employee not worked for entire month are you booking absence to the employee in what cases employee will not work for entire month other than paid and unpaid absence

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Do changes as below in addition to the above.  Note b means one blank:

      1. Wherever you have in the PCRs op'ns as below

            ZERO=bRNA

            ADDWTb2005

         Result of the above op'ns: 

          If w/t 2005 had any of rate, number or amt, it would still exist in IT; you are just adding zero).

        

        replace with

            ZERO=b2005

      This means w/t 2005 will have no rate, num nor amt, if there was any before. 

      2. var VAR9 has no.of worked days in rate field.  As you require the total amt of w/t's 1000, 1006 & 1016 by the number of days added to the rate field.   So replace

           AMT/&bVAR9

         with

           RTE=&bVAR9

           DIVID ARA

      Hope this helps.

      br, JG