How to find student total, average and grade using DataTable activites?

HI @Vaishnav_Tej

Can you tell us how did you need to calculate the grade

Check out this thread for Grade

How about this expression

(From d In Dtread.AsEnumerable
Group d By k=d("Sno").ToString.Trim, k2=d("Sname").ToString.Trim Into grp = Group
Let sum = grp.Sum(Function (x) CDbl(x("Sub1").toString.Trim)+CDbl(x("Sub2").toString.Trim)+CDbl(x("Sub3").toString.Trim))
Let avg = sum/3
Let ra = New Object(){k,k2,grp.First()(2),grp.First()(3),grp.First()(4),sum,avg,grp.First()(7)}
Select r = DtClone.Rows.Add(ra)).CopyToDataTable

Check out the XAML file

Total&AVG.xaml (7.4 KB)

image

image

Regards
Gokul