Hi all,
I’ve had some success with your suggestion, yefritavarez, thanks alot.
I created Tax Band 1, Band 2, Band 3 and so on to do the evaluation. However if you have about 15 bands to deal with and each requiring two rules (only a single formula can be applied per rule so you must evaluate twice for true and false - which is very tedious by the way), you end up having about 15 Salary Components on the payslip.
Isn’t there an elegant way of aggregating the bands into one e.g. Total Taxes = X given that Total Taxes will be calculated using the Tax Bands above?
Any suggestions are welcome. Thanks.