How to calculate a particular datacolumn sum using datatable or structured format?

HI @Vidhi_Patel

How about this expression

(From d in dtData.AsEnumerable Where Not (isNothing(d(2)) OrElse String.IsNullorEmpty(d(2).toString.Trim)) Select v = CDbl(d(2).toString.Trim)).Sum(Function (x) x)

Regards
Gokul

1 Like