Kindly try with this expression
Inside the FOR EACH ROW ACTIVITY
Use the first assign activity Int_input1 = Convert.ToInt32(row(6).ToString)
Where Int_input1 is a variable of type int32 defined in the variable panel
And next a assign activity like this Int_input2 = Convert.ToInt32(row(6).ToString)/cal*(Convert.ToInt32(row(10).ToString))
Now final assign activity like this int_output = Int_input1- int_input2
Kindly try this and let know for any queries or clarification
Cheers @Raja.G
we can use LOOKUP DATATABLE activity
–use EXCEL APPLICATION SCOPE and pass the file path as input and inside the scope use READ RANGE activity and get the output with a variable of type datatable named dt
–now use a FOR EACH ROW activity and pass the variable dt as input
–inside the loop use assign activity like this str_input = row(1).ToString
–then followed by that use LOOKUP DATATABLE ACTIVITY where in the property
panel mention these
input - str_input.ToString
datatable - dt
Lookup column name - “Emp No1”
Out Result - str_output
Target Column Name - “CTC P.M”