How to pass empty cell null values in datatable?

[lrtetala (Lakshman Reddy)]

Hi @domsmgtmeet22

Please check this

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,

Regards,