Hi All, @Gokul001 ,
I am trying to add memory of same user using LINQ query like in below screenshot but It is failing when the value is like “1.006.869”
LINQ query
(From d In dt_ExtractDataTable.AsEnumerable
Group d By k=d(“User ID”).toString.Trim Into grp = Group
Let nj = grp.Sum(Function (x) CDbl(x(“Memory (Net)”).toString.Trim))
Let ra = New Object(){k,grp.First()(1),nj}
Select r = dt_Clone.Rows.Add(ra)).CopyToDataTable
Screenshot of value when facing error
Error Message
Memory Usage Group Assign: Conversion from string “1.006.869” to type ‘Double’ is not valid.
Related question