Sum the values in the column

Hi, I am a beginner in uipath. I am trying to add the values of a column and compare it to another variable from webpage. I have read many forums about suming values grouped by column. However, It’s not working for me. Pls do advise on how to do this.
Thank you xoxo

1 Like

@sangasangasanga if u talking about excel column, use read column activity. Use output of that in for each and inside convert each value to integer and add to temporary variable. u will get required output

@sangasangasanga,Did you check this

1 Like

Yup and I got it thanks. Basically put this code in assign - dt2.AsEnumerable.Sum(Function(x) Convert.ToDouble(x(“ColumnName”).ToString.Trim) )

Hi, can i enter variable string in the place of column name? like this

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

instead of

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