I am using a Db for calcualting pension. Pension is admissible on gross pension and then increases are added in gross pension. Every increase (percentage) is added in previous record and shown in current record. I am attaching the db as well illustrated the same as under:
- Gross Pension : 660
Increase in pension 2017 10% 726 10% of 660 and plus 660 Increase in Pension 2018 15% 835 15% of 726 plus 726 Increase in Pension 2019 10% 918