x Want to participate? Join the group to interact
  • State Suggested Answer
  • Replies 4 replies
  • Answers 1 answer
  • Subscribers 9 subscribers
  • Views 2062 views
  • Users 0 members are here
Browse Forums
Announcements
219
topics
26
replies
General Discussion
588
topics
1k
replies
HR General Discussion
228
topics
155
replies
Soreya

Heading Formula

SUGGESTED
Posted By

Afternoon

I please need some assistance in the a formula generation for the heading for the  Medical Aid employee and employee contribution

This is my challenge the company pays only 75% of the employee medical aid and the 25% gets paid by the overall.

But for Example the total amount of the medical Aid is 8500 for the employee then 75% which is 6375 but the company only pays a maximum of 5000 per employee then the balance is then carried to the employee contribution 1375

So 2125 will be paid by the employee with the 1375 from the balance amount carried to the employee.

Please is anyone that can assist me with this formula on the heading for employee and employer contribution

Regards 

Soreya

Parents Reply
  • 0 in reply to Shazi
    SUGGESTED

    Quite simple to do. Had to make some assumptions to write a heading.

    In my example the total amount paid is calculated on Heading MED_CONTR, but can easily be replace with a variable, depending on your setup.

    I would recommend to headings, one for Deduction and one for Co Contribution.

    MED_AID_ER > MIN((R_MED_CONTR*0.75),5000)

    MED_AID_EE > R_MED_CONTR - R_MED_AID_EE

Children
No Data

*Community Hub is the new name for Sage City