Using variable instead of column name - to sum

Help
1

Continuing the discussion from Sum the values in the column:

Would like to know if i can use variables in the place of column name.

dt3.AsEnumerable.Sum(Function(x) Convert.ToDouble(x(“columnname”).ToString.Trim) )

dt2.AsEnumerable.Sum(Function(x) Convert.ToDouble(x(“(Bill “+numBill.ToString+”)”).ToString.Trim) )

As the 2nd piece of code isn’t working

Thank you xoxo

2

HI @sangasangasanga,

dt2.AsEnumerable.Sum(Function(x) Convert.ToDouble(x(""+numBill.ToString+"").ToString.Trim))

what exception are you getting?

Regards,
Arivu

3

Convert.ToDouble(x(numBill.ToString)) should work

4

Hi @arivu96, it not working.

This is my code:
dt2.AsEnumerable.Sum(Function(x) Convert.ToDouble(x(“(Bill “+numBill.ToString+”)”).ToString.Trim))

FYI: numbill is a variable with generic value type

image
image806×440 20.7 KB

Pls help thank you.

5

Hi @Uemoe , where do I add it in?

If i add it in the below code, gives me validation error.

6

Hi, please help if this is possible.

7

There could possibly be a value that is not a number in that column. You probably want to check that the value is a number with inline If condition.

dt2.AsEnumerable.Sum(Function(x) If(isNumeric(x("(Bill “+numBill.ToString+”)").ToString.Trim), Convert.ToDouble(x("(Bill “+numBill.ToString+”)").ToString.Trim), 0))

So if value is not a number, it will use a zero.