How to calculate totel in datatable?

[lrtetala (Lakshman Reddy)]

Hi @saninfo273

Please check this

How to calculate total in entire datatable?

Hi @domsmgtmeet22 Can you try below (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 [image] Regards,

(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:

Output:

Cheers!!