I am creating payroll system for Indian government employee. I have Some problem in creating dynamic formula and also fetch its result.
Suppose we have basic salary = 5000 and gross salary is 20,000
So gross amount is divided in below category:
TA = 10% of gross
HRA = Basic + gross * 20 /100
TA ON DA =
CA = TA * 15 / 100
MA = Basic + TA
PPF = Gross * 5 /100
I want above categories (TA, DA< HRA) should be dynamic and their formula also should be dynamic and when i fetch the formula, it gave me value according to formula.
Note: I don't want to add more modules for category if there is change in future we could change this or add new more category dynamically
Is this should be possible or not ?
Thanks