How to sum all values in a column of data Table and how to change String to Boolean

[Hnin_Phyu]

Please Help me!!!
How to sum all values in a column of data Table and how to change String to Boolean?

Please Check Photo!!!
DataTable

Trying this

Variable

[Gokul001 (Gokul Balaji)]

Hi @Hnin_Phyu

How about this expression?

(From d in dtData.AsEnumerable Where Not (isNothing(d("Column Name")) OrElse String.IsNullorEmpty(d("Column Name").toString.Trim)) Select v = CDbl(d("Column Name").toString.Trim)).Sum(Function (x) x)

Regards
Gokul

[ppr (Peter Preuss)]

DataTable.Compute(… will return a result of DataType: Object
One of several object is to convert it into a Double as you had done

The Compute method is short and powerfull, but also very sensitive, when the values are not within the expectations (blanks, other formarts)

So a more control we can achieve e.g. with LINQ

[HowTo] LINQ - First Start # Min | Max | Sum | Average Operator

This HowTo gives an introductory overview of the aggregation Operators: Min, Max, Sum, Average Introduction The aggregation operators are used to retrieve from a collection a particular result by setting the contained items into a relationship. Overview I – Input P – Processing O – Output {2,12,-8,6,14,5} get the lowest value -8 {2,12,-8,6,14,5} get the highest value 14 {2,12,-8,6,14,5} sum up all values 31 {2,12,-8,6,14,5} get the average of all values 5.17 Constraints P…

Convert.ToBoolean, CX methods. But more important which String value should be converted?