While using a Linq query, I get this error - Assign: Input string was not in a correct format

IEnum = (From p In dtGLmovement.AsEnumerable() Group p By obj_p= New With {Key.P_Mapping=p.Item(“Mapping”)} Into MG= Group Select new with { .Mapping=obj_p.P_Mapping,.Balance_Today=MG.Sum(Function( r ) Double.Parse(r.Item(“Balance_Today”).ToString())),.Balance_Yesterday=MG.Sum(Function( r ) Double.Parse(r.Item(“Balance_Yesterday”).ToString()))}).ToList

I use a linq query and i get the above error “Assign: Input string was not in a correct format”

Looking forward to the support from the forum.

we would assume, that some values are not parseable. Within the immediate panel we can run an anlysis LINQ to find such values for a next inspection and solution adaption

Due to Null Values