I m trying to sum up a column in datatable and add the sum in last row.I tried below
convert.ToDecimal(dat.Compute(“SUM(amount)”,"[amount] IS NOT NULL"))
dat.AsEnumerable().Sum(Function(row) row.Field(Of Decimal)(“amount”))
i get diff error for each.one specifiedn below
Assign: Specified cast is not valid.
How can i do that