Get average of column with double variables

Please I have a column with doubles, and I want to compute the average. It is not working out. Pls help.

what have you done so far?

we can use the YourDataTableVar.Compute(“Sum([YourColName])”, “”) method

or doing it with a LINQ statement

In case of Blank values or values within an invalid format we have to do some cleansing / preprocessing to avoid failling conversions