How do I get the total of a column in datatable?

[chenderson (Cary Henderson)]

Good evening @The_Dudeman_sweet,

Please check out the following link and let me know if it resolves you’re issue:

How to sum all values in a column of an excel/Datatable?

Hi @lora, Use this alternate lambda expression. I’m not an expert but I was able to understand this easily and put this into Studio quickly. [image] dt.AsEnumerable.Sum(Function(x) If(IsNumeric(x(“Column2”).ToString.Trim),CDbl(x(“Column2”).ToString.Trim),0)) sum is of type System.Double Regards.