Cannot get sum of the specific column's values

Help Activities
, ,
1

Hello guys,

I’m trying to get sum of the values of specific columns. I have no problem with one line named columns. For Example;
image

I can use this code for sum: myData.AsEnumerable.Sum(Function(x) Convert.ToDouble(x(“Program”).ToString.Replace(“,”,“.”)) ).ToString

But when i try for two line named for this code i got this error;

image
image713×267 8.59 KB

I tried column name as;
“Net”+vbLf+“Tutar (TL)”
“Net”+Environment.Newline+“Tutar (TL)”

But it did not work. How can i solve this? Thank you

2

column shouldnt contains the new line just change the column name and try

3

But i used vbLf in filter data table and it worked

image

4

just try to debus and check the output how its looking like after read from sheet, then you can get. may be even any white space there error will occur

5

try using column index, if your column positions are fixed, like here the required column index is =10 , so try x.Item(10)
OR
as suggested by Raj , before using this linq query check rename the column using

dt.columns("Net"+vbLf+"Tutar (TL)").columnname="Net Tutar (TL)"

then use the linq query ,
once done rename the column back to normal

6

i got this error after column name change

image
image708×244 7.95 KB

7

Hello @Oguzhan_Celik

Please print the value in a message box and check whether the Column name is valid.
Make sure there are no unwanted spaces and symbols.

image