Marks adding for students

[ramshiva_reddy]

Dear Team,

Please help me with the task.
Find the attached document. I need the output as mentioned in expected output sheet
Team Training - Assignment 2.xlsx (11.3 KB)

[arjunshenoy]

Hi @ramshiva_reddy

Read the input sheet & add 3 columns to the data table using the activity ‘Add Data Column’. hen, please use the following query in the ‘Invoke Code’ activity:

yourDt.AsEnumerable.ToList.ForEach(Sub(row)

row("Total Marks") = (Cint(row("Subject1 ")) + Cint(row("Subject1 ")) + Cint(row("Subject1 "))).ToString

row("Percentage") = (Cint("Total Marks") * 100)/300

row("Status") = (If(Cint(row("Percentage")).ToString))>=70,"Pass","Fail")

End Sub)

Hope this helps,
Best Regards.

[Jithesh_R (Jithesh Karkera)]

@ramshiva_reddy ,
Check this workflow

MarksAdd.zip (2.3 KB)

Output :

Regards,

[ramshiva_reddy]

Thank you for your immediate response.
But I’m getting an error at the assign activity for Total marks

[Jithesh_R (Jithesh Karkera)]

@ramshiva_reddy ,
Please Provide correct column Names Sometimes if there is any spaces in the column Names it will throw errors like this.

Regards,

[ramshiva_reddy]

Thank you bro… Now the error has been sorted and looks good
Got it.