How to calculate sum of total in datatable?

[lrtetala (Lakshman Reddy)]

Hi @saninfo273

Please check this

How to calculate totel in datatable?

Hi @saninfo273 Please check this [image] (From d In DT.AsEnumerable Let t = {"KTN","KCN","KHC", "KCH","KHO","KSM","KTV"}.Sum(Function (x) Convert.ToInt32("0" & d(x).toString.Trim)) Let ra = d.ItemArray.Take(d.ItemArray.Length - 1).Concat({t}).ToArray Select DT.Clone.Rows.Add(ra)).CopyToDataTable Input: [image] Output: [image] Cheers!!

(From d In DT.AsEnumerable
 Let t = {"Column1","Column2","Column3", "Column4","Column5","Column6","Column7"}.Sum(Function (x) Convert.ToInt32("0" & d(x).toString.Trim))
 Let ra = d.ItemArray.Take(d.ItemArray.Length - 1).Concat({t}).ToArray
 Select DT.Clone.Rows.Add(ra)).CopyToDataTable

Output:

Regards,