How to calculate total?

[pravallikapaluri]

Hi @domsmgtmeet22

Check this thread,It might helps you

How to calculate sum of total in datatable?

Hi @saninfo273 (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 [image] Hope it helps!!

How to calculate sum of total in datatable?

Hi @saninfo273 Please check this [image] (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: [image] Regards,

Hope it helps!!