How to sum the column values using LINQ

Help Activities
, ,
3

Thanks for your response @Yoichi

But, I have 25 columns in the input excel Like in the screenshot

image
image975×225 5.66 KB

In that Dt, i need to take only the Sum value

Expected Output

image

I have done my workflow like in the below

  1. Filter the data Table

  2. Sum all the column one by one

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

image

  1. After that i will sum all the value

  2. Used Add data Row activity