Hi @siva_sankar
use for each datatable activity to iterate into each row of the excel , use assign and perform the mathematical operations to assign the appropriate values
Use for each datatable activity & pass the read range output variable
inside for each
use assign activity
Currentrow(“Obtained_mark”)=Currentrow(“English”)+Currentrow(“Urdu”)+Currentrow(“Physics”)+Currentrow(“Math”)+Currentrow(“Chemistry”)+Currentrow(“Boilogy”)
Currentrow(“Percentage”)=**Currentrow(“English”)+Currentrow(“Urdu”)+Currentrow(“Physics”)+Currentrow(“Math”)+Currentrow(“Chemistry”)+Currentrow(“Boilogy”))/600)*100 **