HRA will be 12 % of Basic
TA will be 4% of Basic
If employee is on project, bonus will be 4500
Hi Bhairavi,
For calculating salary you can use Calculator step
For Adding Bonus to salary, you can Use Filter rows step to segregate Employee working on Project and add Bonus to the filtered Rows using Calculator step.
thank you.
but how to calculate 12% on basic in calculator
How to combine those steps after filtering?
Hi! Harshita,
In the two branches after Filter Rows you can provide Excel Writer Steps. You can write to the same file in both the Excel Writer Steps.