Retrieving rate value information for an option not selected in the enrollment page (Fast Formulas)

Summary:

Hello,

 

We are facing an issue with Benefits Module concerning a Plan and multiple options. Business Requirement is that we have a plan named Medical & Surgical Catastrophe Cover. We have 6 options within the plan, 1M,2M,3M,4M,5M and 10M.

We have 2 standard rates for every option, one is Primary as Rate Display Type and one is Others.

The “Others” one stored the flat amount for the respective option.

For eg:

1M - Others = 100 Rs

2M - Others = 257 Rs

3M – Others = 395 Rs

 

Now the requirement is that if an employee of a specific grade (Grade 14 for example) chooses the option 1M. The employer pays the full amount and the employee pays nothing. Now if the same employee of Grade 14 opts for a higher option, let’s say 2M. The employer will pay 100 Rs and the employee has to pay the difference that is 157 Rs.