# Sum of the values in the column

how to sum the values in the column which is of type double
how to sum and save that at the edge of the column

@anjani_priya

Dim sum As Double = dt.AsEnumerable().Sum(Function(row) If(row.Field(Of Double)(“ColumnName”), 0.0))

Assuming you want to store the sum at the end of the column

Dim sumRow As DataRow = dt.NewRow()
sumRow(“ColumnName”) = sum

You can try like this

`DT1.AsEnumerable().Sum(Function(row) row.Field(Of Double)("Salary")).ToString`

`"A"+(RowsCount+1).ToString`

Hi

→ Calculate the sum: Use an Assign activity to calculate the sum of the values in the double column. You can use the following LINQ expression:
totalSum = dt.AsEnumerable.Where(Function(row) IsNumeric(row(“ColumnName”))).Sum(Function(row) CDbl(row(“ColumnName”)))

where:

→ dt is the data table variable
→ ColumnName is the name of the double column
→ totalSum is the variable to store the sum
→ Add a new row: Use an Add Data Row activity to add a new row at the edge of the data table.
Set the sum value: Use the Set Value at Column Index activity to set the value in the first column of the new row to the calculated sum. The column index will be 0 if you want to add the sum at the beginning of the data table.

@anjani_priya

Dim totalsum As Integer=0
For Each row As datarow In dt.AsEnumerable
totalsum=totalsum+CInt(row(0))
Next row

Cheers!!

what is the sum datatype

check this

@anjani_priya

Change the datatype to System.String

error

@anjani_priya

DT1.AsEnumerable().Sum(Function(row) row.Field(Of Double)(“Salary”)).ToString

Change the Sum variable datatype to String

i have changed and iam getting this error