I have a row with empty column and when tried to sum it, it is failing with string not in a correct format.
Ex; Document Amount = $1200.99
dtOpenInoviceFiltered.AsEnumerable.Sum(Function(x) Convert.ToDouble(x(“Document Amount”).ToString.Replace(“$”,“”).Trim)).ToString
any leads?