How to Calculate TA, HRA & Total salary of employees

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.

Hi! Bhairavi,

Here is a snapshot of a Calculator step to calculate salary. You can also have constant values in the calculations. such as - basic salary*.12