Skip to Content
Former Member
Sep 15, 2014 at 11:22 AM

Factoring based on Gross pay


Dear Experts,

We have a bit complex scenario regarding mid month joining and separation proration. Its like, Gross salary is reduced by the total absence amount.

Formula is like: {Prorated Housing (Housing/30days x no.of days no worked)/Hourly Rate (Basic/195) + Total no. of hours not worked}/195 * Gross salary.

I have been able to segregate this proration calculation of basic and housing by using factor 1 and 3 respectively and both individually has been reduced as per the formula given above i.e. Prorated Housing (Housing/30days x no.of days no worked), Hourly Rate (Basic/195 x number of hours worked).

Now issue is how we can achieve this reduction on Gross salary scenario with our reduction factors, which is basically assigned wagetype wise in Pr.class 10.