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

[sebuvance (Vincent)]

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.

[ppr (Peter Preuss)]

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

[Gangadhar_Athili]

Due to Null Values